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

Hi, 
It does not work

originals:

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

    That's weird. Does the ROUND function work?

     

     

    or....

    VALUE(FORMAT())?

     

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

      doesn't work because i have a scientific number

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