Forum Discussion
Helper IVformat 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
10 Replies
PaulDBrownCommunity 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
TitoHi,
It does not work
originals:- PaulDBrown
That's weird. Does the ROUND function work?
or....
VALUE(FORMAT())?
- Tito
doesn't work because i have a scientific number
- Tito
1,00054E+16 to 1,00054 *****
- Greg_Deckler
Tito PaulDBrown Um, at the risk of pointing out the obvious, 1.00054E+16 is in no way, shape or how equivalent to 1.00054. Like, at all. If you want to get 1.00054 from 1.00054E+16 you are going to need to divide by like 1E+16, right?
- PaulDBrown
OMG!b you are soo right! LOL!More fool me for assuming the "," was the decimal delimiter (which is so in my whereabouts...). Apologies Tito
