Working with DAX Iterators

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

Ratings 4.78 / 5.00

What You Will 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

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.