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