CEILING function

Description

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

Syntax

CEILING (<number>, <significance>)

Parameters

Sr.No. Parameter & Description
1

number

The number you want to round, or a reference to a column that contains numbers.
2

significance

The multiple of significance to which you want to round.

Return Value

Number rounded as specified.

The return type is usually of the same type of the significance parameter, with the following exceptions −

  • If the number parameter type is currency, the return type is currency.

  • If the significance parameter type is Boolean, the return type is integer.

  • If the significance parameter type is non-numeric, the return type is real.

Remarks

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

Example

= CEILING(4.6,1) returns 5. 
= CEILING(4.6,2) returns 6. 
= CEILING(-4.6,-1) returns -5. 
= CEILING(-4.6,-2) ) returns -6.
dax_functions_mathematical_trigonometric.htm
Advertisements