Forum Discussion
Anonymous
7 years agoNot applicable
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
- Gordonlilj
Solution Sage
Hi,
In the power query editor you can round down and up under the transform tab
- AnonymousNot applicable
Thanks very much, Gordon. No idea how I missed that.