From the course: Power BI Data Methods (2019)

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Joining sets of data

Joining sets of data

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Joining sets of data

“

- [Instructor] Those of you who identify as Excel power users, use formulas to create Excel tables that join data with other sources and lookup keys into a single, consolidated data table. Power BI, however, performs better when we join related tables after loading in the model view when they still remain separate tables as opposed to merging them together in a single query in the ETL process. We can think of the relationships between tables in two ways. The first is the relationship between data tables and lookup keys, which typically leverages a many-to-one relationship. The second way to think of the relationships between tables is with the many-to-many relationship. Think of this as blending or aggregating two data fields with a shared ID. But unlike the many-to-one relationship, the second table can have many instances of the ID in the same way that we see those ID occurrences in the first table. This is a new…

Contents