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.

Data Modeling · 23. Februar 2022

The concept of extended tables is at the core of the query performance of Power BI datasets, but it is often overlooked. This article will hopefully change this.

Data Modeling · 20. Januar 2022

This article explains provides an introduction to relationships and why relationships can be considered a sword that helps to chop vast amounts of data into tiny pieces.

Data Modeling · 27. Dezember 2021

Data modeling and understanding the physical layer are comparable with being a good driver and a good car mechanic. It's unnecessary to excel in both areas. Still, it helps tremendously when driving an F1 car through uncharted terrain if there is some understanding of how an F1 car works if repair becomes necessary.,

Data Modeling · 28. Februar 2021

Object Level Security (OLS) helps to protect our data assets inside Power BI. OLS can be applied to a table or just a single column.

Power Query · 18. Januar 2021

I tend to create tables using M or a combination of point-and-click and M, because these tables are treated as base tables if the model is refreshed and for this reason these tables will benefit from all the compression magic, whereas tables created using DAX are not that well compressed.

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.

Power BI · 13. Juni 2020

A common search strategy has to combine multiple items with an AND instead of the default OR. This Power BI file contains two DAX measures solving a search operation with the fancy name: relational division

Data Modeling · 06. Juni 2018

This post shows how a dynamic member called Other can be used for Data Visualizations in Power BI in addition to the common requirement of the visualization of the TOP N or BOTTOM N members. A solution is used that utilizes a combination of data modeling and DAX.

Data Modeling · 16. März 2018

This post describes approaches how to virtual relationships between tables can be established using the DAX function TREATAS() and also approaches how to create physical relationships instead.