Forum Discussion

Tito's avatar
Tito
Icon for Helper IV rankHelper IV
4 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
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

That's weird. Does the ROUND function work?

 

 

or....

VALUE(FORMAT())?

 

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

doesn't work because i have a scientific number

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Are the original columns set as type decimal number?

    Otherwise, in Power Query, use the Extract option in the ribbon and select 7 for number of characters and then format as a decimal number

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

      General number:


      decimal number: