Forum Discussion
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 looking for.
Thanks much
5 Replies
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
AnonymousThank you for your response, I have already tried that approach but is not working for me. So basically I'm only looking for the initial number that is rounded.
If you are using a matrix visualization or maybe even a table, you can specifically set the decimal places of the column by going editing the Field Properties.
-Parker
