Power BI Self-Paced DAX Advanced

£120.00£5,000.00

In this self-paced online Power BI DAX Advanced, which is suitable for experienced Power BI users who are already comfortable with writing complex DAX formulas, delegates will look at the advanced aspects of DAX. The main topics covered are Calculation groups; Exposing DAX to the User; Grouping Functions; Combining Tables with DAX; Manipulating Filters; Data Lineage; and Debugging DAX Code.

SKU: GCOM-DAXSP-103 Category:

Description

In this self-paced Power BI DAX Advanced, which is suitable for experienced Power BI users who are already comfortable with writing complex DAX formulas, delegates will look at the advanced aspects of DAX. The main topics covered are Calculation groups; Exposing DAX to the User; Grouping Functions; Combining Tables with DAX; Manipulating Filters; Data Lineage; and Debugging DAX Code.

Course Outline

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

Exposing DAX to the User

Using DAX What-if Parameters
The GENERATESERIES Function
Letting the User Control Time Intelligence

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

Data Lineage

What is Data Lineage?
Controlling data lineage with the TREATAS Function

Debugging DAX Code

Using the Performance Analyzer
Running Code in DAX Studio
Using Define Measure
Using Define Dependent Measures
Redefining Measures

Additional information

Date

Single User, Up to 10 Users, Up to 20 Users, Up to 30 Users, Up to 40 Users, Up to 50 Users, Up to 60 Users, Up to 70 Users, Up to 80 Users, Up to 90 Users, Up to 100 Users