Power BI - Dax Training Course

DAX

Commonly Used DAX Functions
Sum, Average, Count, DistinctCount
Create a measure table
Copying and Moving Measures
Use Variables in calculation
Different granularity: calculate allocated weight
Filter context
Evaluation Contexts and Relationships
Understand the use of CALCULATE
Table Functions: ALL, ALLEXCEPT, FILTER
Table Functions: DISTINCT, VALUES
Advanced Evaluation Context DAX  
Context transition
Iterator -> nested row context
Row context and Totals
Row context and cumulative total
 
Time Intelligence prerequisites
Time intelligence functions MTD, QTD, YTD, SamePeriodLastYear
YTD, MTD with CALCULATE
Rolling totals for different periods
IF, HasOneValue
Using a Safe Divide Function
Using the Blank() Function
Build an Example Time Intelligence Report
Creating Dynamic titles
Using parameter table
What is scenarios
DAX STUDIO:
Dax as a query language
Capturing and debugging queries with Dax Studio
Power BI referencing