Common · Knowledge
Data Analysis Expressions
Formula and data query language
Data Analysis Expressions (DAX) is the native formula and query language for Microsoft PowerPivot, Power BI Desktop and SQL Server Analysis Services (SSAS) Tabular models. DAX includes some of the functions that are used in Excel formulas with additional functions that are designed to work with relational data and perform dynamic aggregation.
From Wikipedia
Data Analysis Expressions (DAX) is the native formula and query language for Microsoft PowerPivot, Power BI Desktop and SQL Server Analysis Services (SSAS) Tabular models. DAX includes some of the functions that are used in Excel formulas with additional functions that are designed to work with relational data and perform dynamic aggregation. It is, in part, an evolution of the Multidimensional Expression (MDX) language developed by Microsoft for Analysis Services multidimensional models (often called cubes) 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.
Text: Wikipédia, CC BY-SA 4.0. ·
Related cards
-
★★★
Microsoft Power BI
Business analytics service by Microsoft
-
M★
M
Programming language developed by Microsoft
-
O★
ODX
File format
-
B★★★
Business intelligence
Strategies, technologies, and practices used by enterprises for the data analysis and management of business information to support strategic decision-making
-
★★★★★★
Microsoft Excel
Spreadsheet editor, part of Microsoft 365
-
★★★
Business Process Execution Language
Language for specifying actions within business processes with web services