TechNet
Export (0) Print
Expand All

ROUNDUP Function (DAX)

 

Rounds a number up, away from 0 (zero).

Syntax

ROUNDUP(<number>, <num_digits>)

Parameters

TermDefinition
numberA real number that you want to round up.
num_digitsThe number of digits to which you want to round. A negative value for num_digits rounds to the left of the decimal point; if num_digits is zero or is omitted, number is rounded to the nearest integer.

Return Value

A decimal number.

Remarks

ROUNDUP behaves like ROUND, except that it always rounds a number up.

  • If num_digits is greater than 0 (zero), then the number is rounded up to the specified number of decimal places.

  • If num_digits is 0, then number is rounded up to the nearest integer.

  • If num_digits is less than 0, then number is rounded up to the left of the decimal point.

Related Functions

ROUNDUP behaves like ROUND, except that it always rounds a number up.

Example

The following formula rounds Pi to four decimal places. The expected result is 3.1416.

=ROUNDUP(PI(),4)

Example: Decimals as Second Argument

Description

The following formula rounds 1.3 to the nearest multiple of 0.2. The expected result is 2.

Code

=ROUNDUP(1.3,0.2)

Example: Negative Number as Second Argument

Description

The following formula rounds the value in the column, FreightCost, with the expected results shown in the following table:

Code

=ROUNDUP([Values],-1)

Comments

When num_digits is less than zero, the number of places to the left of the decimal sign is increased by the value you specify.

FreightCostExpected Result
13.2520
2.4510
25.5630
1.3410
345.01350

See Also

Math and Trig Functions (DAX)
ROUND Function (DAX)
ROUNDDOWN Function (DAX)
MROUND Function (DAX)
INT Function (DAX)

Community Additions

Show:
© 2016 Microsoft