POWER BI · 2 Days

Microsoft Power BI - DAX+

Comprehensive 2-day DAX mastery for experienced Power BI users. Covers the complete DAX formula language, advanced filter context, time-intelligence, performance tuning, dataflows, incremental refresh, and DAX Studio testing.

Duration: 2 Days From £550/day (up to 8 learners) 1-to-1 or Groups of up to 8 Learners (Larger by Arrangement) M365 (Desktop & Web) · Office 2021/2024 Certificate · Manuals · 1-Year Support

Complete Course Syllabus

DAX Fundamentals & Core Functions

  • DAX structure, Formatter, and Column Calculations vs Measures
  • Aggregations: SUM/SUMX, COUNT/COUNTX, DISTINCTCOUNT, AVERAGE/AVERAGEX
  • Logical functions: IF, SWITCH, AND/OR

Filter Context & Time-Intelligence

  • CALCULATE, RELATED, RELATEDTABLE, FILTER, HASONEVALUE, ALL, USERELATIONSHIP
  • Time-intelligence: DATEADD, SAMEPERIODLASTYEAR, EOMONTH, DATESBETWEEN
  • Period totals: TOTALMTD, TOTALQTD, TOTALYTD, PREVIOUSMONTH/YEAR

Advanced Functions, Variables & Tables

  • LOOKUPVALUE, EARLIER, COMBINEVALUES, SUMMARIZE, ROLLUP, DIVIDE, TOPN
  • Declaring variables to optimize and debug DAX code
  • Calculated tables, Calendar tables, UNION, and Parameter tables
  • Testing and optimizing DAX queries using DAX Studio

DAX+ Enterprise & Optimization Topics

  • Incremental refresh across multiple tables
  • Troubleshooting & improving query efficiency and refresh management
  • Working with Dataflows and Matrix table variances
  • Decision framework: Column vs Measure & function applicability
  • Creating automated variances (Week on week, MoM, and YoY)
Copied to Clipboard ✓

Ready to Share