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.
Just got a request from leadership to change the way our basis points are displayed. A third party vendor created this model and I'm tasked with managing it going forward.
Here is the DAX formula they created:
The expected result where it's highlighted is (10,000bps) and (8,182bps). For some reason, in the IF statement, it's not recognizing the negatives, and it's just multiplying by 1, as opposed to 10000 like it's supposed to do.
Any ideas on how to get this to work?
Thx
Solved! Go to Solution.
@peterg0417 Should be this:
* IF ( FormatToUse IN { "0bps;(0bps)"}, 10000, 1 ),
Hi @peterg0417 ,
Try modifying your IF statement as below:
@peterg0417 Should be this:
* IF ( FormatToUse IN { "0bps;(0bps)"}, 10000, 1 ),
Ahh yes, that makes sense
This whole custom formatting is very new to me so thank you for the quick 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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |