Skip to main content Skip to Ask Learn chat experience

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English

Note

Access to this page requires authorization. You can try signing in or changing directories.

Access to this page requires authorization. You can try changing directories.

In this article

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

Data Analysis Expressions (DAX) Overview

DAX Syntax Specification for PowerPivot

Related Sections

Date and Time Functions (DAX)

Statistical Functions (DAX)

Logical Functions (DAX)

Filter Functions (DAX)

Math and Trigonometric Functions (DAX)

See Also

Concepts

Data Analysis Expressions (DAX) Overview


Additional resources


  • Last updated on 2011-05-23

In this article

en-us
Your Privacy Choices
  • AI Disclaimer
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Consumer Health Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2026