Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |