# 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

## Useful Video Courses

Video

#### Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Video

#### Mastering DAX Studio

Featured

24 Lectures 2 hours

Video

#### DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours