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!
You may just add IIf function inside a calculated measure.
I have the table visual in the below format. MTD and YTD are calculated Measures.
|ABC in $||10000.00||2000000.00|
|HGY in $||2800.00||765378.00|
|GYH in %||75.09||83.7|
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.