More Advanced DAX

Basically "More Advanced DAX" is not generally more sophisticated. From my point of view most of the times more advanced DAX statements stand out by a deeper understandig of the mechanics, the intricate workings of basic concept, like Filter Context and the lot. Sure sometimes it's also helpful to know why a certain DAX function is more appropriate than the other.

 

In this section I will combine DAX mechanics in a way that may be not that obvious.

Combine TAble iteratorS to calculate a future gain

Some time ago I stumbled upon a question at the Power BI Community how to calculate a future gain of a value. In this blog post I describe how TABLE iterators can be used to simulate an recursive usecase.