Power BI DAX Advanced
£395.00 – £9,750.00
In this one-day 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. In this one-day Power BI DAX Advanced Training Course, 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. By the end of this course, delegates should feel far more confident in writing complex DAX measures. 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.
Description
In this one-day Power BI DAX Advanced Training Course, 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. By the end of this course, delegates should feel far more confident in writing complex DAX measures.
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 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
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 | 4 Feb 2022(Tutor-led, Online), 13 Apr 2022(Tutor-led, Online), 10 Jun 2022(Tutor-led, Online), 12 Aug 2022(Tutor-led, Online), 28 Oct 2022(Tutor-led, Online), Private Training for up to 10 Users, Private Training for up to 20 Users, Private Training for up to 30 Users, Private Training for up to 40 Users, Private Training for up to 50 Users, Private Training for up to 60 Users, Private Training for up to 70 Users, Private Training for up to 80 Users, Private Training for up to 90 Users, Private Training for up to 100 Users |
---|