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.

A dynamic other - the remainder

A quite common requirement for data visualizations in Power BI is not just to show the TOP N members of a "dimension" (eg customers or products), but also the rest. This blog post explains how this can be achieved.