Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a calculated column where I have values in percentage.
What I want is one more column
Which shows value of last column if it is less than 300% and if it is more than 300 percent then it must show 300%+
Solved! Go to Solution.
Dear friend,
I wanted to do with fields with different values and limit.
I used measure and it's done .
Thanks for prompt response.
I came to know one more trick .
We can also use emoji in DAX coding / column coding , power bi will paste it.(use """") arround them .
Isnt it cool .
I used🚩 this flag in following code
Measure = var a = Sumx('Table'[Overload%])
var b = Related('Variant'[serial_Weight])
Return if(a<b,b&"🚩",a)
hi @Sujit_Thakur - You can create a calculated column as shown below - the final column will be in TEXT format
Proud to be a Super User!
Dear friend,
I wanted to do with fields with different values and limit.
I used measure and it's done .
Thanks for prompt response.
I came to know one more trick .
We can also use emoji in DAX coding / column coding , power bi will paste it.(use """") arround them .
Isnt it cool .
I used🚩 this flag in following code
Measure = var a = Sumx('Table'[Overload%])
var b = Related('Variant'[serial_Weight])
Return if(a<b,b&"🚩",a)
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |