DAX Language
Reference : DAX-06
Price : Contact us
Level & Prerequisites :
Duration : 2 days
Basic knowledge of Power BI or Power Pivot
Understanding of data modeling concepts
Description
This course provides a deep and practical introduction to the DAX (Data Analysis Expressions) language used in Power BI, Analysis Services, and Power Pivot. Participants will learn how to create powerful calculations, build analytical models, and enhance reporting capabilities through hands‑on exercises and real‑world scenarios.
Public
Power BI users
Data analysts and BI developers
Excel Power Pivot users
Anyone working with tabular models
Course objective
Understand the fundamentals and logic of the DAX language
Create calculated columns, measures, and tables
Use essential DAX functions (CALCULATE, FILTER, SUMX, etc.)
Apply time intelligence functions
Manage context transition and evaluation context
Optimize DAX formulas for performance
Build advanced analytical models using DAX
Content
Introduction to DAX and evaluation context
Calculated columns vs. measures
Aggregation and iterator functions
CALCULATE and filter context manipulation
Time intelligence functions
Advanced DAX patterns
Performance optimization
Practical exercises and case studies