Power BI DAX Advanced

Description

This one-day Power BI DAX Advanced Training Course dives deep into the most powerful aspects of DAX, equipping experienced users to master complex DAX measures with confidence. Participants will learn advanced techniques, including Calculation Groups, user-driven DAX, sophisticated grouping and filtering, and data lineage control—giving them the skills to build highly interactive, optimized Power BI reports with advanced data insights.

Learning Objectives

• Create What-if parameters using DAX functions like GENERATESERIES to empower users with control over DAX measures.
• Utilize advanced grouping functions such as SUMMARIZE, SUMMARIZECOLUMNS, and GROUPBY to dynamically aggregate data within reports.
• Combine tables with DAX using functions like UNION, CROSSJOIN, INTERSECT, and EXCEPT to extend analysis across multiple datasets.
• Manipulate and refine filters with advanced filter functions including ALL, ALLSELECTED, REMOVEFILTERS, and USERELATIONSHIP to achieve precise filtering and control over data visibility.
• Apply DAX Path functions (e.g., PATH, PATHCONTAINS, PATHLENGTH) to create hierarchies and navigate parent-child relationships in complex datasets.
• Build and manage Calculation Groups using Tabular Editor to streamline and enhance measure calculations, including the use of SELECTEDMEASURE for dynamic analysis.
• Define and apply dynamic format strings in Calculation Groups to control and customize measure formatting based on context.

Participants will leave with a high level of proficiency in DAX, ready to leverage advanced techniques to write complex, optimized DAX measures and enhance Power BI reports with user-driven interactivity and deeper insights.

Course Outline

Exposing DAX to the User

Using DAX What-if Parameters
The GENERATESERIES Function
Letting the User Control your DAX Measures

Grouping Functions

SUMMARIZE
SUMMARIZECOLUMNS
GROUPBY BY

Combining Tables with DAX

UNION
CROSSJOIN
INTERSECT
EXCEPT

Manipulating Filters

ALL and ALLEXCEPT
ALLSELECTED and ALLCROSSFILTERED
REMOVEFILTERS and KEEPFILTERS
EARLIER and EARLIEST
The USERELATIONSHIP Function

DAX Path Functions

Overview of Path Functions
Using the PATH Function
The PATHCONTAINS Function
The PATHLENGTH Function
Using PATHITEM to Create a Hierarchy

Calculation groups

Overview of Calculation Groups
Overview of Tabular Editor
Creating a Calculation Group
SELECTEDMEASURE and SELECTEDMEASURENAME
Using Calculation Groups with Time Intelligence
Exchanging Measures using Calculation Groups
Defining Format Strings
Making Format Strings Dynamic