## How does the ISO.CEILING function (DAX) work?

ISO.CEILING function (DAX) Rounds up a number, to the nearest integer or to the nearest significant multiple.

## ISO.CEILING Formula Syntax

``ISO.CEILING(<number>[, <significance>]) ``

## How do you use the ISO.CEILING function?

It returns a rounded number to the nearest integer or to the nearest relevant multiple. It works whether the given number is positive or negative.

## Considerations when using the ISO.CEILING function

DAX has two CEILING functions −

• CEILING − Same as the Excel CEILING function.
• ISO.CEILING − Follows the ISO-defined behavior for determining the ceiling value.

Both DAX CEILING and ISO.CEILING functions return the same value for positive numbers.

However, they return different values for negative numbers.

When using a positive multiple of significance, both CEILING and ISO.CEILING round negative numbers upward (toward positive infinity).

When using a negative multiple of significance, CEILING rounds negative numbers downward (toward negative infinity), while ISO.CEILING rounds negative numbers upward (toward positive infinity).

## Formula examples using the ISO.CEILING function

``=ISO.CEILING(-4.42,0.05) ``

## Related Course Modules 