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.132...
Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    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")
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
3 years ago

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")