Working with DAX Iterators

Name: Working with DAX Iterators
Rating: 4.6 (45 reviews)

Master the use of DAX iterators and the magic of context transitions that allow them to perform magic

Created byRandy Minder

Last updated 7/2020

English

What you'll learn

How to use DAX iterators
How context transitions make iterators work
The importance of iterator cardinality
The amazing GENERATE iterator function and the incredible things it can allow you to do
Getting the most out of SUMX, AVERAGEX and TOPN
Understanding RANKX and how it uses a lookup table to generate rank values

Course content

5 sections • 37 lectures • 3h 24m total length

Introduction1:51
An introduction to this course

Using iterators4:48
A brief discussion on using iterators
Iterator cardinality6:29
In this lecture we discuss the concept of cardinality and the importance it plays in iterators and nest iterators
Iterators and context transitions15:19
In this lecture we talk about the importance of context transitions when working with iterators and, how without them, we could not accomplish what we want

SELECTCOLUMNS / ADDCOLUMNS16:08
In this lecture we talk about the first two iterators that return functions, SELECTCOLUMNS and ADDCOLUMNS
TOPN and GENERATE9:35
In this lecture we discuss the TOPN and GENERATE iterators and some of the amazing things you can do with these two functions working together
GENERATEALL4:34
The GENERATEALL function is almost identical to GENERATE except for one important detail
FILTER3:10
In this lecture we briefly describe the FILTER function as an iterator function
SAMPLE4:05
In this lecture we talk about the SAMPLE iterator function

SUMX and SUM13:05
In this lecture we discuss the SUMX iterator and how it compares to an aggregator like SUM
MAXX and MAX8:57
In this lecture we discuss MAX, MAXX, MAXA and the associated MIN family of functions
AVERAGEX and AVERAGE17:23
In this lecture we discuss the AVERAGE and AVERAGEX function and some of the very interesting things you can do with AVERAGEX
COUNTX and COUNT1:44
In this lecture we discuss two simple pairs of functions, COUNT and COUNTX
RANKX - Part 112:51
This is part 1 of an in-depth look into the RANKX iterator function
RANKX - Part 214:19
This is part 2 of an in-depth look into the RANKX iterator function
CONCATENATEX7:34
In this lecture we discuss the CONCATENATEX function and an interesting real-world scenario where this function can be very useful
PERCENTILEX11:35
In this lecture we discuss how to calculate percentiles and quartiles using the PERCENTILEX iterator

Exercise 11:44
Exercise 1
Exercise 21:03
Exercise 2
Exercise 31:15
Exercise 42:24
Exercise 4
Exercise 52:23
Exercise 62:36
Exercise 6
Exercise 75:17
Exercise 7
Exercise 84:29
Exercise 8
Exercise 94:11
Exercise 9
Exercise 102:19
Exercise 10
Exercise 113:18
Exercise 11
Exercise 123:36
Exercise 12
Exercise 130:32
Exercise 13
Exercise 142:09
Exercise 14
Exercise 156:40
Exercise 15
Exercise 162:44
Exercise 16
Exercise 170:41
Exercise 17
Exercise 181:01
Exercise 18
Exercise 191:58
Exercise 19
Exercise 201:06
Exercise 20

Requirements

The only requirement is a desire to become a better DAX developer

Description

As a DAX developer, you've probably used iterators already. In fact, it's quite possible you have used iterators and didn't even know they were iterators. You may not even know what the word iterate even means, at least in relation to DAX and table processing.

In this course we take iterators to the next level, by demonstrating the most common uses of iterators and by introducing new iterators you have probably never used. Learning how to leverage iterators in your code is an important skill to acquire. Using iterators and context transition together will allow you to perform data manipulation you may not have thought was possible.

You will learn how to get the most out of DAX iterators and use context transitions to your advantage. If your goal is to become a DAX expert, you must master the use of these important functions. And, you must understand how they work.

Finally, you will be able to test your knowledge of iterators by working through 20 questions and exercises.

Who this course is for:

DAX developers who have at least some DAX experience

Working with DAX Iterators

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Overview3 lectures • 27min

Iterators which return a table5 lectures • 38min

Other Iterators8 lectures • 1hr 27min

Time to test your knowledge20 lectures • 51min

Requirements

Description

Who this course is for: