Data Analysis Expressions

<p>Data Analysis Expressions (DAX) is the native formula and <a href="/facts/Query_language/Sa6K4xXM">query language</a> for <a href="/facts/Microsoft/nGIDDXdx">Microsoft</a> <a href="/facts/PowerPivot/xGbopq4j">PowerPivot</a>, <a href="/facts/Power_BI/xqJUmU2w">Power BI</a> Desktop and <a href="/facts/Microsoft_Analysis_Services/92MhPt5Q">SQL Server Analysis Services</a> (SSAS) Tabular models. DAX includes some of the functions that are used in <a href="/facts/Microsoft_Excel/Ezal6G75">Excel</a> formulas with additional functions that are designed to work with <a href="/facts/Relational_model/VFf4dDIU">relational data</a> and perform dynamic <a href="/facts/Data_aggregation/vbhNVlJp">aggregation</a>. It is, in part, an evolution of the <a href="/facts/MultiDimensional_eXpressions/7ppno3el">Multidimensional Expression</a> (MDX) language developed by Microsoft for Analysis Services multidimensional models (often called <a href="/facts/OLAP_cube/dLTSCod6">cubes</a>) combined with Excel formula functions. It is designed to be simple and easy to learn, while exposing the power and flexibility of PowerPivot and SSAS tabular models.
</p>

Data Analysis Expressions open-in-new

Data Analysis Expressions