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.
Duration: 1 Day
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
Introduction to DAX & Basic Functions
- What is DAX, DAX syntax structure, and using DAX Formatter
- Calculated Columns vs Measures: when and why to use each
- Basic aggregations & iterators: SUM/SUMX, COUNT/COUNTX, DISTINCTCOUNT, COUNTROWS, AVERAGE/AVERAGEX, MIN/MAX
Logical & Filter Context Functions
- Logical branching with IF, SWITCH, AND, OR, and COALESCE
- Understanding Row Context vs Filter Context
- Core filter functions: CALCULATE, RELATED, RELATEDTABLE, FILTER, HASONEVALUE, VALUES, ALL, USERELATIONSHIP, ISFILTERED
Time-Intelligence & Advanced Functions
- Period comparisons: DATEADD, SAMEPERIODLASTYEAR, EOMONTH, DATESBETWEEN
- Running period totals: TOTALMTD, TOTALQTD, TOTALYTD, PREVIOUSMONTH/YEAR
- Advanced lookups & aggregations: LOOKUPVALUE, EARLIER, SUMMARIZE, DIVIDE, TOPN
Variables, Calculated Tables & DAX Studio
- Declaring variables (VAR / RETURN) to simplify and debug DAX code
- Creating Calculated Tables, Calendar tables, UNION, and Parameter tables
- Introduction to testing and formatting queries in DAX Studio
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 · 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.
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
→