Edit

Math and Trig functions

  • Article

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 category

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.
ACOT Returns the arccotangent, or inverse cotangent, of a number.
ACOTH Returns the inverse hyperbolic cotangent 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.
CONVERT Converts an expression of one data type to another.
COS Returns the cosine of the given angle.
COSH Returns the hyperbolic cosine of a number.
COT Returns the cotangent of an angle specified in radians.
COTH Returns the hyperbolic cotangent of a hyperbolic angle.
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.
MOD Returns the remainder after a number is divided by a divisor. The result always has the same sign as the divisor.
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.
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.
SIN Returns the sine of the given angle.
SINH Returns the hyperbolic sine of a number.
SQRT Returns the square root of a number.
SQRTPI Returns the square root of (number * pi).
TAN Returns the tangent of the given angle.
TANH Returns the hyperbolic tangent of a number.
TRUNC Truncates a number to an integer by removing the decimal, or fractional, part of the number.