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

Query and data modeling languages

Owen Duncan|Last Updated: 3/16/2018
1 Contributor

Data Analysis Expressions (DAX)

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 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 Power Query M Reference.

© 2018 Microsoft