DAX stands for Data Analysis Expression, it is the Microsoft language to manipulates data in Microsoft SSAS Tabular cubes as well as in Power BI, and in Excel PowerPivot.
The DAX library is a Powerful and user-friendly Microsoft library of different type of functions addressing different purposes. The DAX functions can be time intelligence functions or filter functions for example.
What DAX abbreviation stands for ? It is Data Analysis Expressions
Indeed, the Data Analysis Expressions language combines these functions with operators into formulas to build expressions to manipulate data.
The DAX, for Data Analysis Expressions functions can be time intelligence functions or filter functions for example. The Data Analysis Expressions combines these functions with operators into formulas to build expressions to manipulate data.
DAX functions types examples
This list is not exhaustive but simply a few examples of the functions that the DAX language offers:
- Aggregations functions like SUM or AVERAGE
- Time and date functions like TODAY, DATEDIFF, MONTH or QUARTER
- Text functions like REPLACE, CONCATENATE and FORMAT
- The very innovative Time intelligence functions like PREVIOUSMONTH, SAMEPERIODLASTYEAR or TOTALYTD
Check out our DAX functions section with articles on how to create calculations and aggregations using formulas with simple examples.
Check out also the MS Excel section on how to build pivot tables, from the Excel section.