Forum Discussion

Stuznet's avatar
Stuznet
Helper V
8 years ago

Format Decimal Number

I can change the number format in Excel but How do I round the number to oneth in Dax?     Sum column is what I want to round to the Oneth, so the result in the Rounded column is what I'm loo...
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey Stuznet

 

You have 2 options to accomplish this. If your number will always be formatted with 1 decimal place, go to the Modeling tab and you can set the number of decimals you want by changing "Auto" to 1. This is found in the section where you set the Data type and format.

 

If your requirements require you to set the number of decimals dynamically, you can do that by changing the value to text and specifying the number of decimal places. If you're interested, see this video I just posted on exactly that.

 

https://www.youtube.com/watch?v=FO6e3rjSslQ

 

Hope this helps,

Parker