DAX

DAX · 09. März 2024

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.

DAX · 17. September 2023

This article describes the process of how I solve complex DAX, of course there is some fancy DAX included.

DAX · 14. Dezember 2022

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.

DAX · 26. Dezember 2021

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).

DAX · 17. Januar 2021

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.

DAX · 02. November 2020

This article will provide a different approach to tackle a common requirement, determining the previous value given a current date.

DAX · 04. März 2020

This blog provides an introdution into some universal truths, of course things like evaluation context, or data lineage will be mentioned