DAX (Data Analysis Expressions) is the analytical engine behind Microsoft Power BI, Power Pivot for Excel, and SQL Server Analysis Services Tabular models. While many professionals can build reports, fewer truly understand how DAX behaves within data models. Without mastery of filter context, evaluation context, and CALCULATE logic, dashboards can produce inaccurate or inconsistent results.
The Conquering DAX 2019 [FASTRACK] course is a 3-day instructor-led workshop designed for Power BI users, Power Pivot users, and Analysis Services developers who want to write reliable, scalable, and advanced DAX formulas. This program moves beyond fundamentals and focuses on deep conceptual clarity supported by structured lab exercises.
The course begins with core DAX foundations, including calculated columns, measures, aggregation functions, conditional logic, variables, and error handling. Participants then progress into advanced table functions and filtering techniques such as DISTINCT, ALLSELECTED, RELATEDTABLE, and complex filter manipulation.
A major focus of the program is evaluation context. Participants gain a strong understanding of:
Row context and filter context
Context transition
Relationship behavior in calculations
Common context-related errors
The CALCULATE function receives detailed coverage, as it is central to advanced DAX modeling. Participants learn how CALCULATE modifies filter context, how to apply KEEPFILTERS, and how to structure compact syntax correctly.
The course also covers:
Iterators such as MINX, MAXX, and RANKX
Time intelligence functions including DATEADD, DATESINPERIOD, running totals, and YOY% comparisons
Hierarchies and parent-child models
Segmentation techniques
Many-to-many relationships and bidirectional filtering
Hands-on labs reinforce learning through real analytical scenarios including ranking customers, percentage calculations, segmentation modeling, and semi-additive measures.
By the end of the training, participants will be able to:
Write advanced DAX formulas confidently
Control filter behavior and evaluation context accurately
Implement time intelligence and ranking logic
Handle complex enterprise data modeling challenges
Frequently Asked Questions
Is this course HRDC claimable?
Yes. This course is HRDC claimable subject to approval and compliance with HRD Corp requirements. Organizations may apply for funding support according to current HRDC guidelines.
Can this course be customized for my organization?
Yes. The course can be customized based on your organization’s Power BI data models, reporting structures, and advanced analytical requirements to ensure direct business relevance.
Will I learn advanced DAX functions like CALCULATE and ALLSELECTED?
Yes. This course provides in-depth coverage of advanced functions including CALCULATE, ALLSELECTED, KEEPFILTERS, RANKX, MINX, MAXX, and table functions, supported by structured lab exercises.
Does this course explain filter context and evaluation context clearly?
Yes. The course covers row context, filter context, context transition, and relationships in detail to eliminate common DAX calculation errors and improve formula accuracy.
Does this training include time intelligence and complex data modeling?
Yes. Participants learn running totals, YOY comparisons, moving averages, semi-additive measures, segmentation techniques, and many-to-many relationship handling within enterprise data models.