how do we remove decimal places if the column value has whole number else display decimal places?

[murali_r]

I have both whole number and decimal values in single column . I want to display as it is (whole number should display same and decimal number should display two decimal places) . But by default it displays always two decimal places even if it is whole number . How do I acheive it ?

Please update any one knows.

[Greg_Deckler · Accepted solution]

You could potentially do something like:

Measure 3 = IF(MOD(SUM(Budgets[Value]),2)=0,FORMAT(SUM(Budgets[Value]),"#####"),FORMAT(SUM(Budgets[Value]),"####.##"))

[BuistJF]

This has work great thank you!

Only issue I have is that is is leaving some of the whole numbers with a decimal point and nothing after it, but not all, see image below. These are whole numbers so a little strange any thoughts? 

Works great for the decimal place. Logic is identical to above though have reduced to a single decimal point, though issue occured with 2.

[BuistJF]

I have got around this issue by adjusting the DAX: 

Metric Value = IF(MOD(SUM('DSET_FUNNEL (2)'[True Value]),1)=0,FORMAT(SUM('DSET_FUNNEL (2)'[True Value]),"#####"),SUM('DSET_FUNNEL (2)'[True Value]))