Forum Discussion
Tito
Helper IV
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
PaulDBrown
Community Champion
Community ChampionAre 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
TitoHelper IV
Helper IVGeneral number:
decimal number: