Math and Trigonometric Functions (DAX)

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.

The numeric data types used by DAX functions are described in the section, Data Types Supported in PowerPivot Workbooks.

In This Section

ABS Function (DAX)

CEILING Function (DAX)

EXP Function (DAX)

FACT Function (DAX)

FLOOR Function (DAX)

INT Function (DAX)

ISO.CEILING Function (DAX)

LN Function (DAX)

LOG Function (DAX)

LOG10 Function (DAX)

INT Function (DAX)

MROUND Function (DAX)

PI Function (DAX)

POWER Function (DAX)

QUOTIENT Function (DAX)

RAND Function (DAX)

RANDBETWEEN Function (DAX)

ROUND Function (DAX)

ROUNDDOWN Function (DAX)

ROUNDUP Function (DAX)

SIGN Function (DAX)

SQRT Function (DAX)

SUM Function (DAX)

SUMX Function (DAX)

TRUNC Function (DAX)

Reference

Getting Started with Data Analysis Expressions (DAX)

DAX Syntax Specification

Related Sections

Date and Time Functions (DAX)

Statistical Functions (DAX)

Logical Functions (DAX)

Filter Functions (DAX)

Math and Trigonometric Functions (DAX)

See Also

Other Resources

Getting Started with Data Analysis Expressions (DAX)