Power BI - Dax training course

DAX

• Examples with SUM, AVG, COUNT, DISTINCTCOUNT
• Common DAX patterns
• Scenarios for FILTER, SELECTEDVALUE
• Ranking functions, TOPN
• When to use the X-functions
• Create filtered measures with CALCULATE
• Virtual tables
• Percents of Total with ALL, ALLSELECTED, ALLEXCEPT

BEST PRACTICES

• Safe DIVIDE
• Housekeeping with measure groups
• Interim measures
• Measures for conditional formatting
• Use of DAX variables
• Using the BLANK() function

CONTEXT

• Be clear on Measures vs Columns
• Understand Filter Context
• Propagate filter through Context Transition
• Iterate with Row Context
• Implement ABC Classification

RELATIONSHIPS

• Filter flow direction through relationships
• RELATED vs LOOKUPVALUE
• Data tables vs lookup tables
• Accommodating different table granularities
• Data lineage

TIME INTELLIGENCE 

• Benefits of Dates table
• Year-on-year comparisons
• SAMEPERIODLASTYEAR, PARALLELPERIOD
• Cumulative Total to Date calculations
• Fiscal years/quarters
• Special accounting periods
• Pro-rata view for incomplete trading periods
• Events in progress
• Budget vs Actual comparison methodology

PRODUCTIVITY  MISC

• Understand IntelliSense syntax notation
• Dynamic titles, CONCATENATEX
• Introduction to DAX Studio
• DAX query examples
• Capture DAX query traffic
• Identify and fix performance issues
• Use Calculation Groups
• What-if analysis
• Design for budget and actual figures on same chart