cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
keerthipindi Regular Visitor
Regular Visitor

Round of few cells in a calculated measure

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!

3 REPLIES 3
Community Support Team
Community Support Team

Re: Round of few cells in a calculated measure

@keerthipindi,

 

You may just add IIf function inside a calculated measure.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
keerthipindi Regular Visitor
Regular Visitor

Re: Round of few cells in a calculated measure

Hi Sam,

 

I have the table visual in the below format. MTD and YTD are calculated Measures.

 

NameMTDYTD
ABC in $10000.002000000.00
HGY in $2800.00765378.00
GYH in %75.0983.7
JIH512

 

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

keerthipindi Regular Visitor
Regular Visitor

Re: Round of few cells in a calculated measure

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