Mastering DAX Video Course


This workshop is a complete video course about the DAX language. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to learn and master the DAX language.

The goal of the course is to teach all the features of DAX, providing the knowledge to write formulas for common and advanced business scenarios. The course is made of more than 10 hours of lectures, and other 8 hours of individual exercises. You can watch the videos at anytime and the system will keep track of your advances. Within the course you can download the material for all the exercises.

Prerequisite: Attendees need to have a basic knowledge of the data modeling in Power Pivot for Excel, or Power BI Desktop, or Analysis Services Tabular modeling.


Course Curriculum
  1. Presentation of Mastering DAX
    •   Presentation of Mastering DAX
  2. Exercise, labs, slides, and demos
    •   How to download and complete exercises
    •   Download demos
    •   Download exercises (Power Pivot for Excel)
    •   Download exercises (Power BI)
    •   Slides of the video course
  3. Introduction to DAX
    •   Introduction to DAX
    •   What is DAX?
    •   DAX data types
    •   Calculated columns
    •   Measures
    •   Naming convention
    •   Measures vs. calculated columns
    •   Handling errors
    •   Aggregation functions
    •   Counting values
    •   Logical functions
    •   The SWITCH function
    •   Information functions
    •   MAX and MIN functions
    •   Mathematical functions
    •   DIVIDE function
    •   Using variables
    •   Rounding, text, and date functions
    •   Relational functions
    •   Lab number 1
    •   Lab 01 First Steps with DAX
  4. Table functions
    •   Table functions
    •   Introduction to table functions
    •   FILTER function
    •   ALL function
    •   ALLEXCEPT function
    •   Mixing filters
    •   DISTINCT function
    •   VALUES and ALLNOBLANKROW functions
    •   ISEMPTY function
    •   RELATEDTABLE function
    •   Tables and relationships
    •   Calculated tables
    •   Lab number 2
    •   Lab 02 Table Functions
  5. Evaluation contexts
    •   Evaluation contexts
    •   Introduction to evaluation contexts
    •   Filter context
    •   Row context
    •   There are always two contexts
    •   Context errors
    •   Working with evaluation contexts
    •   EARLIER in nested row contexts
    •   EARLIER and variables
  6. CALCULATE function
    •   CALCULATE function
    •   Introduction to CALCULATE
    •   CALCULATE examples
    •   Filter are tables
    •   OR conditions in CALCULATE
    •   Clear filter on one column only
    •   CALCULATE tasks
    •   Example: ratios and percentages
    •   Variables and evaluation contexts
  7. Evaluation contexts and relationships
    •   Evaluation contexts and relationships
    •   Introduction to evaluation contexts and relationships
    •   Row context and relationships
    •   Filter context and relationships
    •   CALCULATE examples
    •   Filtering many columns
    •   Filter arguments in CALCULATE
    •   FILTER and CROSSFILTER functions
    •   HASONEVALUE function
    •   ALLSELECTED function
    •   Context transition
    •   Automatic CALCULATE in measures
    •   Equivalent filter context
    •   Circular dependency
    •   Conclusions about relationships
    •   Lab number 3
    •   Lab 03 Evaluation Contexts
  8. Building a Date table
    •   Building a Date table
    •   Introduction
    •   CALENDAR function
    •   CALENDARAUTO function
    •   Mark as Date table
    •   Set sorting options
    •   Multiple dates
  9. Working with iterators
    •   Working with iterators
    •   Introduction to iterators
    •   Example: daily average
    •   Useful iterators
    •   MIN-MAX sales per customer
    •   Statistical and financial functions
    •   RANKX function and examples
    •   RANKX recap and details
    •   Lab number 4
    •   Lab 04 Iterators
  10. Time intelligence in DAX
    •   Time intelligence in DAX
    •   Introduction to time intelligence
    •   Aggregations over time
    •   Year to date functions
    •   Previous year and DATEADD functions
    •   Example: previous year calculation
    •   PARALLELPERIOD function
    •   Running total
    •   Moving annual total
    •   Semi additive measures
    •   Calculations over weeks
    •   Time intelligence conclusions
    •   Lab number 5
    •   Lab 05 Time Intelligence
  11. Querying with DAX
    •   Querying with DAX
    •   Introduction
    •   DAX Studio
    •   EVALUATE syntax
    •   FILTER and CALCULATETABLE functions
    •   SUMMARIZE and SELECTCOLUMNS functions
    •   CROSSJOIN function
    •   GENERATE function
    •   Tables, relationships, and data lineage
    •   ROW, LOOKUPVALUE, and CONTAINS functions
    •   TOPN function
    •   UNION, INTERSECT, and EXCEPT functions
    •   SUMMARIZECOLUMN and GROUPBY functions
    •   Query measures
    •   Parameters in queries
    •   DAX measures in MDX queries
    •   Querying in DAX - conclusions
    •   Lab number 6
    •   Lab 06 Querying DAX
  12. Advanced filter context
    •   Advanced filter context
    •   Introduction to advanced filter context
    •   Filter propagation and strange results
    •   Key topics
    •   Base tables and expanded tables
    •   Context propagation
    •   Filter is on columns, not tables
    •   Example: compute a simple percentage
    •   First recap of filter context
    •   Definition of a filter context
    •   Filter context operators
    •   Example: filter context puzzle
    •   KEEPFILTER function
    •   Dangers of SUMMARIZE
    •   Recap of advanced filter context
    •   Inside ALLSELECTED
    •   Lab number 7
    •   Lab 07 Advanced Filter Context
  13. Hierarchies in DAX
    •   Hierarchies in DAX
    •   Introduction to hierarchies
    •   Parent-child hierarchies
    •   Hiding levels in parent-child hierarchies
    •   Parent-child hierarchies recap
    •   Lab number 8
    •   Lab 08 Hierarchies
  14. Advanced relationships
    •   Advanced relationships
    •   Introduction to advanced relationships
    •   Ambiguity in bidirectional filters
    •   USERELATIONSHIP function
    •   Multi-column relationships
    •   Static segmentation
    •   Dynamic segmentation
    •   Working at different granularity
    •   Many-to-many relationships
    •   New and returning customers
    •   Lab 09 Advanced Relationships


User Reviews (10)
Free Trial or Buy the course