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)
Related Training
More Power Bi Courses
POWER BI · 2 Days
Microsoft Power BI Desktop Foundation
Self-service business intelligence, connecting data sources, Query Editor data shaping, data modeling, visualisations, and publishing reports.
View Full Syllabus
→
POWER BI · 1 Day
Microsoft Power BI Desktop DAX
Optimise speed and efficiency using DAX formula language, basic/advanced functions, variables, calculated tables, and parameter tables.
View Full Syllabus
→
EXCEL · 1 Day
Microsoft Excel Introduction
Master workbook navigation, efficient data handling, and essential formulas. Create professional-looking spreadsheets, design clear charts, and produce polished print-ready reports.
View Full Syllabus
→