Power Query · 19. März 2023

An introduction to M data structures and how understanding these structures helps to apply more complex transformations to your data.

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.

Power Query · 29. Mai 2022

Retrieve values from remote tables inside a query step (anonymous function / inline function)

Data Visualization · 16. Mai 2022

Field parameters allow the report designer to switch the content of a visual with ease. This feature allows the report consumers to interact with data without needing to create their reports

Data Modeling · 24. April 2022

One of the powerful features of the Tabular data model is to extend the model by adding calculated columns and measures. Both objects are defined using DAX, but besides this similarity, they are entirely different beasts. Here you will find guidance when to use what!

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

Tables and their columns are the very foundation of Power BI data models.

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

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