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

[Anonymous]

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.

[Gordonlilj · Accepted solution]

Hi,

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

[Anonymous]

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