£445.00
In this one-day tutor-led online Introduction to Power BI Data Analysis Expressions (DAX), delegates will learn the fundamentals of the DAX language. By the end of the course, delegates will be confident in creating basic calculated columns, calculated tables and calculated measures.
The main topics covered are Calculated Columns; DAX Syntax; Calculated Tables; Measures; Iterator Functions; Understanding Calculation Contexts; and CALCULATE Function Basics.
In this one-day tutor-led online Introduction to Power BI Data Analysis Expressions (DAX), delegates will learn the fundamentals of the DAX language. By the end of the course, delegates will be confident in creating basic calculated columns, calculated tables and calculated measures.
The main topics covered are Calculated Columns; DAX Syntax; Calculated Tables; Measures; Iterator Functions; Understanding Calculation Contexts; and CALCULATE Function Basics.
Welcome to the Course
Downloading the Course Files
DAX Overview
DAX Objects
Calculated Columns versus M Computed Columns
Creating Calculated Columns
Calculated Columns versus Measures
Calculated Columns, Measures and Visuals
Referring to Objects
DAX Operators
Using Variables
Creating Calculated Tables
Creating a Date Table
Cloning a Table
Using the DISTINCT Function
Using the FILTER Function
Creating a Measures Table
Implicit Measures
Measures and the Filter Context
Basic Aggregation Functions
Logical Functions
Implicit and Explicit Iteration
The SUMX Function
The AVERAGEX Function
The COUNTX Function
Calculation Contexts
The Row Context
The Filter Context
Context Transition
CALCULATE Overview
Using CALCULATE with Booleans
Using CALCULATE with FILTER
Using CALCULATE with ALL
Date | 11 November 2024 (Tutor-led, Online), 10 February 2025 (Tutor-led, Online), 14 April 2025 (Tutor-led, Online), 9 June 2025 (Tutor-led, Online), 4 August 2025 (Tutor-led, Online), 6 October 2025 (Tutor-led, Online) |
---|