-
Book Overview & Buying
-
Table Of Contents
DAX for Humans
By :
We have covered enough theory and introduced enough tools, so let’s take a closer look at an example scenario based on a real-world question that appeared in the Power BI Community forums.
To explore this scenario, import the DateTimeTable, Dim_Department, and Tracking_History sheets from the Excel spreadsheet, Chapter15_Data.xlsx which can be found in the GitHub repository for this book: https://github.com/gdeckler/DAX-For-Humans/tree/main/book.
It is worth noting that the DateTimeTable consists of 1,776 rows of data containing a single column called Date with datetime values for each hour of the day between the dates of January 1st, 2020 and March 14th. The Tracking_History table is the main fact table and contains just over 59,000 rows.
Create a relationship between the Dim_Department and Tracking_History tables using the common Department ID columns in both tables. Your semantic model should look like the following:

Figure 15.6: Scenario semantic model
Now...