Forum Discussion
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
That's weird. Does the ROUND function work?
or....
VALUE(FORMAT())?
doesn't work because i have a scientific number
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
General number:
decimal number: