DAX · 09. März 2024
My favorite windowing function - WINDOW
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
DAX from the trenches - how I write complex DAX statements
This article describes the process of how I solve complex DAX, of course there is some fancy DAX included.
DAX · 14. Dezember 2022
Unlock an ample new world by seeing through a window
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
A duration is not the same as datetime!
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
Events and projections
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