The DAX windowing functions have helped me a lot in tackling complex analytical challenges. Nevertheless, I do not use them daily. This means sometimes I need time to regain the “windowing feel” again. This article will shorten the time until I’m thinking “windowing” again. Maybe it might help you as well.
This article describes the process of how I solve complex DAX, of course there is some fancy DAX included.
There are new DAX functions: INDEX, OFFSET, and WINDOW. These functions allow us to compose powerful filter tables that have not been possible before or at least require very complex DAX code. These functions come with additional clauses, namely ORDERBY and PARTITIONBY. PARTITIONBY enables the partitioning of a virtual table.
This article is about durations.
When we are looking at something like this: 2:00
We think, at least most of the people I know, an event that takes 2 hours.
But when we change the notation just a little to 2:00 AM, we think: Whoa, that’s early (or late, depending on the perspective, of course).
There is just one thing that is more satisfying than writing complex DAX measures, and that is avoiding complex DAX due to smart data modeling.
This article will provide a different approach to tackle a common requirement, determining the previous value given a current date.
This blog provides an introdution into some universal truths, of course things like evaluation context, or data lineage will be mentioned