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 All,
I have a calculated measure(YTD and MTD) with values of different data types i.e., %, Ratio, $, number. Is it possible to round of the cells with dollar amount only from 1000.00 to 1000?
Note: The formatting option in the modelling tab is disabled as its a calculated measure.
Thanks in Advance!
@Anonymous,
You may just add IIf function inside a calculated measure.
Hi Sam,
I have the table visual in the below format. MTD and YTD are calculated Measures.
Name | MTD | YTD |
ABC in $ | 10000.00 | 2000000.00 |
HGY in $ | 2800.00 | 765378.00 |
GYH in % | 75.09 | 83.7 |
JIH | 5 | 12 |
While creating If statement in measure, it will not accept to round of a cell in the measure.
It would be great if you can let me know on how to proceed further.
Thanks,
Keerthi
Hi Sam, can you give me the syntax for If statement
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |