# ISO.CEILINGDAX Function (Math and Trig)

Rounds a number up, to the nearest integer or to the nearest multiple of significance.

## Syntax

ISO.CEILING ( <Number> [, <Significance>] )
Parameter Attributes Description
Number

The value you want to round.

Significance Optional

The multiple to which you want to round.

## Return values

Scalar A single value of one these types: currency, decimal, integer.

A number, of the same type as the number argument, rounded as specified.

## Remarks

There are two CEILING functions in DAX, with the following differences:

• The CEILING function emulates the behavior of the CEILING function in Excel.
• The ISO.CEILING function follows the ISO-defined behavior for determining the ceiling value.

The two functions return the same value for positive numbers, but 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).

## Examples

```= ISO.CEILING  ( 10.2, 1 )                   -- Returns 11     (Integer)
= ISO.CEILING  ( 10.7, 1 )                   -- Returns 11     (Integer)
= ISO.CEILING  ( 10.2, 0.5 )                 -- Returns 10.5   (Decimal)
= ISO.CEILING  ( 10.7, 0.5 )                 -- Returns 11     (Decimal)
= ISO.CEILING  ( 10.2, CURRENCY ( 0.5 ) )    -- Returns 10.5   (Currency)
= ISO.CEILING  ( 10.7, CURRENCY ( 0.5 ) )    -- Returns 11     (Currency)
= ISO.CEILING  ( -10.2, 1 )                  -- Returns -10    (Integer)
= ISO.CEILING  ( -10.2, -1 )                 -- Returns -10    (Integer)
= ISO.CEILING  ( -10.7, 1 )                  -- Returns -10    (Integer)
= ISO.CEILING  ( -10.7, -1 )                 -- Returns -10    (Integer)
= ISO.CEILING  ( -10.2, 0.5 )                -- Returns -10    (Decimal)
= ISO.CEILING  ( -10.7, 0.5 )                -- Returns -10.5  (Decimal)
= ISO.CEILING  ( -10.2, CURRENCY ( 0.5 ) )   -- Returns -10    (Currency)
= ISO.CEILING  ( -10.7, CURRENCY ( 0.5 ) )   -- Returns -10.5  (Currency)
```

## Related functions

Other related functions are:

Last update: Nov 20, 2020     » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/iso-ceiling-function-dax

# Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

# Row Context

This expression is executed in a Row Context. Click to read more.

# Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

# Not recommended

The use of this parameter is not recommended.

# Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

# Deprecated

This parameter is deprecated and its use is not recommended.

# DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

### Contribute

Want to improve the content of ISO.CEILING? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.