Forum Discussion
Tito
3 years agoHelper IV
format the number
Hello, everyone How can I format the number 1.00054E+16 to 1.00054 in Power Query or with a DAX function. Thanks
PaulDBrown
3 years agoCommunity Champion
You can establish the decimal places in the formatting options in the ribbon:
Or you can use the ROUND function In DAX:
https://learn.microsoft.com/en-gb/dax/round-function-dax