Forum Discussion

Tito's avatar
Tito
Icon for Helper IV rankHelper IV
3 years ago

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
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

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's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
3 years ago

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