From the course: Power BI Data Methods (2019)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Composite models
- Composite models allow for many-to-many relationships between tables, which removes previous requirements and workarounds, such as introducing new tables for the sole purpose of establishing relationships. Let's create two tables with multiple instances of the same dates in each table and show how the new many-to-many functionality allows us to join or blend these tables together. Let's select Enter Data, where we will create two small sample datasets to test this out with. Here is an excel file called Sample blending data, that I will copy and paste into Power BI. You can find these files in your 10-05 exercise files folder. We first copy table one and put it into Power BI, and label it as table one. I'm just going to load both of the tables to see how this works, because we are testing this out. And now I copy table two and paste it into Power BI, and label it with the name table two. Now we join the tables…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.