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.

Related Blog Posts


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).

Related Video Tutorials

Formula examples using the ISO.CEILING function


Related DAX Functions


Related Course Modules