Query and Data Modeling Languages

 

Applies To: Microsoft Office 2013, Office 365, Power BI, SQL Server

DAX - Data Modeling Language

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.
To learn more, see the Data Analysis Expressions (DAX) Reference.

Power Query M Formula Language

The Power Query M formula language is a powerful mashup query language optimized for building queries that mashup data. It is a functional, case sensitive language similar to F#, which can be used in SQL Server 2017 Analysis Services, Power BI Desktop, Power Query in Excel, and Get & Transform in Excel 2016.
To learn more, see the Power Query M Reference.

Show: