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.
Some Examples:
DIVIDE
Performs division and returns alternate result or BLANK() on division by 0
SUM
Adds all the numbers in a column.
SUMX
Returns the sum of an expression evaluated for each row in a table.
=ABS([DealerPrice]-[ListPrice])
=ACOS(-0.5) Arccosine of -0.5 in radians, 2*pi/3. 2.094395102
=ACOS(-0.5)*180/PI() Arccosine of -0.5 in degrees. 120
Formula Description Result
=ACOSH(1) Inverse hyperbolic cosine of 1. 0
=ACOSH(10) Inverse hyperbolic cosine of 10. 2.993228
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.
Function Description
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.
RANDBETWE Returns a random number in the range between two numbers you
EN specify.
ROUND Rounds a number to the specified number of digits.
ROUNDDOW Rounds a number down, toward zero.
Function Description
N
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.
