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
Introduction to DAX
Table functions
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
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
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
Building a Date table
  •   Introduction
  •   CALENDAR function
  •   CALENDARAUTO function
  •   Mark as Date table
  •   Set sorting options
  •   Multiple dates
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
Time intelligence in DAX
  •   Introduction to time intelligence FREE
  •   Aggregations over time FREE
  •   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
Querying with DAX
  •   Introduction
  •   DAX Studio
  •   EVALUATE syntax
  •   FILTER and CALCULATETABLE functions
  •   CROSSJOIN function
  •   GENERATE function
  •   Tables, relationships, and data lineage
  •   ROW, LOOKUPVALUE, and CONTAINS functions
  •   TOPN function
  •   UNION, INTERSECT, and EXCEPT functions
  •   Query measures
  •   Parameters in queries
  •   DAX measures in MDX queries
  •   Querying in DAX - conclusions
  •   Lab number 6
  •   Lab 06 Querying DAX
Advanced filter context
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
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

Free Trial or Buy the course