Forum Discussion

New Member

1 year ago

Solved

Data cleaning remove 0 from decimal values X.0

Hi, could you please help me remove 0 in decimal number here? ex: ( 68.0 should be 68 and keep 75.4 as it is ) Thank you!

Super User

1 year ago

Chaimaazyani
Calculated Column:

FormattedNumber = 
IF(
MOD('YourTable'[YourColumn], 1) = 0,
FORMAT('YourTable'[YourColumn], "0"),
FORMAT('YourTable'[YourColumn], "0.0")
)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

New Member

1 year ago

Doesn't work. Same result