Rating 4.55 out of 5 (29 ratings in Udemy)
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
DescriptionAs a DAX developer, you've probably used iterators already. In fact, it's quite possible you …
Rating 4.55 out of 5 (29 ratings in Udemy)
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
DescriptionAs 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 DAXiterators and use context transitions to your advantage. If your goal is to become a DAXexpert, 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.
