Math and Trig 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

CEILING Function

CURRENCY Function (DAX)

EXP Function

FACT Function

FLOOR Function

INT Function

ISO.CEILING Function

LN Function

LOG Function

LOG10 Function

INT Function

MROUND Function

PI Function

POWER Function

QUOTIENT Function

RAND Function

RANDBETWEEN Function

ROUND Function

ROUNDDOWN Function

ROUNDUP Function

SIGN Function

SQRT Function

SUM Function

SUMX Function

TRUNC Function

Reference

Data Analysis Expressions (DAX) Overview

DAX Syntax Specification for PowerPivot

Date and Time Functions (DAX)

Statistical Functions (DAX)

Logical Functions (DAX)

Filter Functions (DAX)

Math and Trig Functions (DAX)

See Also

Concepts

Data Analysis Expressions (DAX) Overview