Understanding and building relationships
As you add tables to your model, you will need to build the relationships that tell the tabular model which tables and fields are related to each other. These relationships enable the calculations that you create to perform correctly. In this recipe, you will create a relationship between the MasterCalendar_T table and the Crash_Data table.
Getting ready
Before starting this recipe make sure you have loaded the Iowa crash data and the MasterCalendar_T table into you model. This recipe shows you how to create a relationship between the two tables.
How to do it...
Left-click the Crash_Date_fx column from the CRASH_DATE table and then drag it to the Date column in the MasterCalendar_T table.
Since MasterCalendar_T is designated as a Date table, the model made the relationship be one-to-many from the MasterCalendar_T to the Crash_Data table.
Double-click on the relationship arrow that was added to bring up the Edit Relationship window. This window allows...
