Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I couldn't find a solution for this, so I really do hope that someone can support with this.
I have calculation where negative values should be converted to zero. Any ideas?
Thanks a lot,
-Kati
Ya we can do .
If ( measure < 0 , 0 , measure )
thats it.
let me know if any further help.
I am wondering if this is the optimal way or if using the function max( measure, 0) performs quicker.
(apologies for ressurecting an old thread!)
Test if the number is negative, and if so, add the abolute value of that number.
That will give you the zero.
IF( [Number] < 0, [Number] + ABS( [Number] ), [Number] )
Cheers,
--Eric.
Have you tried adding a conditional column? See example below. Of course with your own column names. I am the first to admit that this is not very elegant, but it should work until you have a better solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |