Relationships

Once you have imported some data, the next step is creating the relationships between the tables. If you have imported data from a database where primary and foreign keys have already been defined, then these should be imported along with the tables. However, you may find that these relationships are not suitable for your data model. You may also have more than one relationship between tables, where only one will be active. In addition, you may also want to create new relationships.

A relationship is defined by a single column from each table. You cannot use multiple columns to define a relationship, but you can create new columns in each table that consist of multiple columns concatenated together. You can then use these to ...

Get Hands-On Business Intelligence with DAX now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.