ISO.CEILING Function (DAX)

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

Related Support Forum Posts

Accessing Matrix hierarchy levels
Dynamic RANKX with Other Category
Developing Complex Dax functions

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

=ISO.CEILING(-4.42,0.05) 

Related DAX Functions

ceiling
ROUND
ROUNDUP

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.