Working with DAX Iterators
Master the use of DAX iterators and the magic of context transitions that allow them to perform magic
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.
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
Who Should Attend!
- DAX developers who have at least some DAX experience