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.
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 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.,
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).
Before we delve into the realm of Power BI data modeling (or Analysis Services Tabular), it's necessary to understand what this data modeling is all about. A thorough understanding of data modeling is vital because the Power BI data model determines the insights that can be derived and visualized from our data, leading us to better and more actionable decisions. Because we are striving for the ideal data model all the time, others call us obsessed with data modeling 😊 To get this...