Using relationships
A relationship, when modeling relational data, describes the connection between two tables. For instance, there is a relationship between the Customer table and the Sales table in our example. A customer can have multiple sales transactions in the Sales table. To create a relationship between the Customer and Sales tables, we must link CustomerKey from the Customer table to CustomerKey from the Sales table. This linkage enables Power BI to understand that each row of data in the Customer table can have one or more related rows in the Sales table.
To create relationships between tables in Power BI Desktop, we can either use the Model view to drag a column from a table and drop it to the relevant column from the other table, or we click the Manage relationships button from the ribbon. The Manage relationships button appears in several places in the ribbon. The following screenshot shows the Manage relationship window:
Figure 8.31 –...
