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
Copied to Clipboard ✓

Ready to Share