Forum Discussion
Power Query Rounding issue
I am trying to use "Round Conc" column to round any number in "Concentration (%)" to 3 decimal place.
Expectation:
38.4188 -> 38.419 [now it is correct]
0.1315 -> 0.132 [but it now give 0.1320]
27.0996 -> 27.100 [but it now give 27.1]
The code I now use is:
#"Round Conc" = Table.AddColumn(#"Renamed as report - before round", "Round Conc", each Number.ToText(Number.Round(Number.From([#"Concentration (%)"]), 3))),
I have tried changing the data type but it does not work.
I now have to change it to text, split by ".", format the digits to the right of dot to 3 characters. It solves the 27.1 but still 0.1320 is not solved.
Any idea? Thank you all.
Hello, carmenng Number.ToText function has an optional format parameter. Read function description on MS site. Try this:
Number.ToText(Number.Round(Number.From([#"Concentration (%)"]), 3), "N3")
2 Replies
- ChielFaberSuper User
Somebody had a similar issue some time ago. Take a look at:
It seems the Number.ToText and Text.From functions both create the same situation that your dealing with.