Advanced DAX

WHAT YOU'LL LEARN

To have the ability to significantly enhance the analytical value of data models with DAX calculations
To develop a strong understanding of advanced DAX concepts and learn to think like DAX
To understand when and how to use the more advanced DAX functions

This course includes:

Course Description
Outline
Instructor
System Requirements
What to Know Before Class

Course Description

The Advanced DAX course is designed to build on the fundamentals taught in the Introduction to DAX course. This course focuses on the advanced and difficult to comprehend DAX concepts like evaluation context, security, iterator functions and advanced DAX functions. The goal of this course is to give the student the tools necessary to think like DAX and understand the ‘why’ behind how calculations work.

Click here for a downloadable PDF

Outline

Module 00 | Class Introduction

03m 54s total

Module 00A | Why Advanced DAX?

03m 54s

Module 01 | Working with Variables

12m 16s total

Module 01A | Variables

12m 16s

Module 02 | Working with Filter Context

55m 41s total

Module 02A | What is Filter Context?

07m 10s

Module 02B | CALCULATE

13m 56s

Module 02C | FILTER and ALL

15m 31s

Module 02D | ALLEXCEPT

07m 39s

Module 02E | Totals

12m 05s

Module 03 | CALCULATE and Time Intelligence

32m 02s total

Module 03A | YTD and MTD

13m 00s

Module 03B | Rolling Totals

19m 02s

Module 04 | Semi-Additive Measures

25m 66s total

Module 04A | Overview

11m 49s

Module 04B | Opening and Closing Balance

14m 17s

Module 05 | Row Context

30m 63s total

Module 05A | Understanding Row Context and Context Transition

14m 49s

Module 05B | Working with Iterator Functions

16m 44s

Module 06 | Nested Row Context

21m 07s total

Module 06A | Nested Row Context

21m 07s

Module 07 | Error Handling

27m 23s total

Module 07A | Error Handling

27m 23s

Module 08 | Security

52m 07s total

Module 08A | Implementing Basic Security

23m 12s

Module 08B | Dynamic Security

14m 50s

Module 08C | SSAS Tabular Security

14m 45s

Module 09 | Role Playing Dimensions

28m 28s total

Module 09A | Multiple Table Import

12m 16s

Module 09B | USERELATIONSHIP

16m 12s

Module 10 | Advanced DAX Functions

59m 48s total

Module 10A | CONTAINS

14m 44s

Module 10B | FIND

10m 27s

Module 10C | SEARCH AND SUBSTITUTE

16m 37s

Module 10D | ALLSELECTED

10m 32s

Module 10E | RANKX

08m 08s

Instructor

JEREMIAH HERSEY

Trainer
Jeremiah Hersey is a Trainer for Pragmatic Works specializing in the Power Platform. He graduated from the University of North Florida in 2012 and comes with 5 years of teaching experience in high school mathematics. Jeremiah earned the accomplishment every year teaching, of being named one of the Best and Brightest teachers of Florida. His primary focus is helping our customers learn the in and outs of DAX.

System Requirements

Windows 7, Windows 8 or Windows 10
1 GHz or faster CPU
1 GB of available RAM (recommended 2 GB)
20 GB of free hard drive space
Power BI Desktop
**Optional** SQL Server Analysis Services Tabular

What to Know Before Class

A basic understanding of how to create calculated columns and measures, ideally completion of Pragmatic Works’ Introduction to DAX course. The target audience of this course is for power users who are familiar with DAX, but want to take their skills to the next level.

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.

Bonus:

• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!