RoundDown

rounds down to the previous lower number, towards zero.

The RoundDown() function in Power FX is used to round a number down to a specified number of decimal places.

Unlike regular rounding, which may round up or down depending on the value, RoundDown() always rounds the number downwards, ensuring it goes to the nearest lower value.

Syntax

RoundDown(ThisItem.NumberColumn, DecimalPlaces)

ThisItem.Number: The number you want to round down.

DecimalPlaces: The number of decimal places to round to.

Example

If you have a column TotalPrice and want to round it down to 2 decimal places, you can use:

RoundDown(ThisItem.TotalPrice, 2)

For example:

• 12.345 becomes 12.34

• 9.99 remains 9.99 (no change, already rounded down)

Best Practices

You can combine RoundDown() with functions like Sum(), Max(), or Average() to ensure results are always rounded down when calculating aggregate values.