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
Tito's avatar
Tito
Icon for Helper IV rankHelper IV
3 years ago

1,00054E+16 to 1,00054 *****

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 

     

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

    PaulDBrown  Greg_Deckler  
    That's right. But the numbers are not only with 1E +16, there is also 1E +15 etc. as a solution I divided the column by 10000000.
    Thanks for your help