Forum Discussion

carmenng's avatar
carmenng
New Member
3 years ago
Solved

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