RoundUp

rounds up to the next higher number, away from zero.

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

Unlike regular rounding, which rounds up or down depending on the value, RoundUp() always rounds the number upwards, ensuring that it goes to the nearest higher value.

Syntax

RoundUp(ThisItem.NumberColumn, DecimalPlaces)

ThisItem.NumberColumn: The column contains the number values you want to round up.

DecimalPlaces: The number of decimal places to round to.

Example

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

RoundUp(ThisItem.TotalPrice, 2)

For example:

• 12.345 becomes 12.35

• 9.99 remains 9.99 (no change since it is already rounded up)

Best Practices

RoundUp() can be combined with other functions like Sum(), Average(), or Datediff() to ensure the result is always rounded up correctly.