DAX
Introduction to DAX
DAX stands for Data Analysis Expressions. It's a formula and query language used in several Microsoft tools for data modeling and analytics, most commonly in:
- Power BI
- Excel Power Pivot
- Analysis Services Tabular Models (SSAS)
What is DAX used for?
DAX is used to:
- Create calculated columns, measures, and custom tables
- Perform advanced data analysis and calculations on data models
- Build dynamic reports and dashboards
Key Concepts in DAX
| Concept | Description |
|---|---|
| Calculated Columns | Columns added to a table using DAX formulas |
| Measures | Aggregations like sums, averages, counts, or custom logic |
| Row Context | Each row is evaluated individually (important for calculated columns) |
| Filter Context | Filters applied in a report or measure affect calculations |
| Time Intelligence | Built-in functions to handle dates and time-based calculations (e.g., year-to-date, moving average) |
Example
To calculate total sales in Power BI:
Total Sales = SUM(Sales[Amount])
No questions available.