Round of few cells in a calculated measure

[Anonymous]

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!

[v-chuncz-msft]

@Anonymous,

You may just add IIf function inside a calculated measure.

[Anonymous]

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

[Anonymous]

Hi Sam, can you give me the syntax for If statement