Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How do I force values to round down instead of up?

I have a series of aggregated percentage values which I need rounded to two decimal places. Unfortunately default rounding creates the wrong in impression in the case of values like 99.9971 which Power BI rounds up to 100%. Is there any way to force it to round down?

Note: I would prefer to do this without creating a new column or measure, hence my post.

  • Hi,

     

    In the power query editor you can round down and up under the transform tab

     

2 Replies

  • Hi,

     

    In the power query editor you can round down and up under the transform tab

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks very much, Gordon. No idea how I missed that.