Math and Trig functions

The mathematical functions in Data Analysis Expressions (DAX) are very similar to the Excel mathematical and trigonometric functions. This section lists the mathematical functions provided by DAX.

In this section

Function Description
ABS Returns the absolute value of a number.
ACOS Returns the arccosine, or inverse cosine, of a number.
ACOSH Returns the inverse hyperbolic cosine of a number.
ASIN Returns the arcsine, or inverse sine, of a number.
ASINH Returns the inverse hyperbolic sine of a number.
ATAN Returns the arctangent, or inverse tangent, of a number.
ATANH Returns the inverse hyperbolic tangent of a number.
CEILING Rounds a number up, to the nearest integer or to the nearest multiple of significance.
COMBIN Returns the number of combinations for a given number of items.
COMBINA Returns the number of combinations (with repetitions) for a given number of items.
COS Returns the cosine of the given angle.
COSH Returns the hyperbolic cosine of a number.
CURRENCY Evaluates the argument and returns the result as currency data type.
DEGREES Converts radians into degrees.
DIVIDE Performs division and returns alternate result or BLANK() on division by 0.
EVEN Returns number rounded up to the nearest even integer.
EXP Returns e raised to the power of a given number.
FACT Returns the factorial of a number, equal to the series 1*2*3*...* , ending in the given number.
FLOOR Rounds a number down, toward zero, to the nearest multiple of significance.
GCD Returns the greatest common divisor of two or more integers.
INT Rounds a number down to the nearest integer.
ISO.CEILING Rounds a number up, to the nearest integer or to the nearest multiple of significance.
LCM Returns the least common multiple of integers.
LN Returns the natural logarithm of a number.
LOG Returns the logarithm of a number to the base you specify.
LOG10 Returns the base-10 logarithm of a number.
MROUND Returns a number rounded to the desired multiple.
ODD Returns number rounded up to the nearest odd integer.
PI Returns the value of Pi, 3.14159265358979, accurate to 15 digits.
POWER Returns the result of a number raised to a power.
PRODUCT Returns the product of the numbers in a column.
PRODUCTX Returns the product of an expression evaluated for each row in a table.
QUOTIENT Performs division and returns only the integer portion of the division result.
RADIANS Converts degrees to radians.
RAND Returns a random number greater than or equal to 0 and less than 1, evenly distributed.
RANDBETWEEN Returns a random number in the range between two numbers you specify.
ROUND Rounds a number to the specified number of digits.
ROUNDDOWN Rounds a number down, toward zero.
ROUNDUP Rounds a number up, away from 0 (zero).
SIGN Determines the sign of a number, the result of a calculation, or a value in a column.
SQRT Returns the square root of a number.
SUM Adds all the numbers in a column.
SUMX Returns the sum of an expression evaluated for each row in a table.
TRUNC Truncates a number to an integer by removing the decimal, or fractional, part of the number.