# 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 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.
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.
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.