Table of contents
Collapse the table of content
Expand the table of content

Data Analysis Expressions (DAX) Reference

Owen Duncan|Last Updated: 4/19/2018

Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Microsoft SQL Server Analysis Services, Power Pivot in Excel, and Power BI Desktop.

In This Section

New DAX Functions - This article describes new DAX functions included in SQL Server 2016 Analysis Services, Power Pivot in Excel 2016, and Power BI Desktop.

DAX Function Reference - Topics in this section provide in-depth technical reference information for each of the over 200 different DAX functions. Functions are divided into categories such as Statistical, Filter, Data and Time, etc.

DAX Syntax Reference - This topic describes syntax requirements, naming requirements, and different operators and constants used in DAX expressions.

DAX Operator Reference - This topic describes the syntax of individual operators used to create expressions that compare values, perform arithmetic calculations, or work with strings.

DAX Parameter-Naming Conventions - This topic describes parameter naming conventions in DAX expressions.

DAX Queries - This topic describes syntax and parameters for returning table data from a DAX query.

DAX Error Reference – This section includes topics for some of the most common errors returned from DAX.

© 2018 Microsoft