Designing relationships between tables

In a Power BI dataset, relationships between tables determine how queries that involve data from both tables are generated. If you’ve taken an introductory class on Power BI, such as Dashboard in a Day, learning about relationships is a foundational skill for Power BI development. Back in Chapter 2, you determined that the tables have the following key values to establish relationships:

• Date Table: The Date column matches up to the Incident Date column on the Strike Reports table
• Aircraft Type Info: Aircraft Code matches up with Aircraft Class Code on the Strike Reports table
• Engine Codes Info: Manufacturer Code and Model Code are compound keys matching up with AMA and AMO from the Strike Reports table
• Engine Position Info: Engine Code maps to four columns on the Strike Reports table – Engine 1 Position Code, Engine 2 Position Code, Engine 3 Position Code, and Engine 4 Position Code

Let’s go ahead...