DAX Function Reference - Visual Intelligence - page 381

FuNCTIoN DESCrIPTIoN

QUOTIENT(< numerator >,
< denominator >)

Performs division and returns only the
integer portion of the division result.
Use this function when you want to
discard the remainder of division.

RAND() Returns a random number greater

than or equal to 0 and less than
1, evenly distributed. The number
that is returned changes each time
the cell containing this function is
recalculated.

RANDBETWEEN(< bottom >,< top >) Returns a random number between

the numbers you specify.

ROUND(< number >, < num_digits >) Rounds a number to the specified

number of digits.

ROUNDDOWN(< number >,
< num_digits >)

Rounds a number down, toward 0
(zero).

ROUNDUP(< number >, < num_digits >) Rounds a number up, away from 0

(zero).

SIGN(< number >) Determines the sign of a number, the

result of a calculation, or a value in
a column. The function returns 1 if
the number is positive, 0 (zero) if the
number is zero, or -1 if the number is
negative.

SQRT(< number >) Returns the square root of a number.

TRUNC(< number >, < num_digits >) Truncates a number to an integer by

removing the decimal, or fractional,
part of the number.

TIME INTELLIGENCE FuNCTIoNS

Time intelligence functions are provided for work with calendar months, and
the functions are listed in Table B-12.

TABle B-12 Time Intelligence Functions

FuNCTIoN DESCrIPTIoN

CLOSINGBALANCEMONTH(
< expression >, < dates >,
< filter >)

Evaluates the specified expression at
the calendar end of the given month.
The given month is calculated as the
month of the latest date in the dates
argument, after applying all filters.