Manage Many to Many Relationships in Power Pivot

Download the workbook to go along with this video
theexcelclub.co...
Our blog is now powered by #steem - if you have any questions or comments on this video please do post the on the original blog post and not here on KZbin
#excel #powerpivot #powerbi
Relationship connect two or more tables of data together. To connect each table, both tables must have something in common. There are two types of relationship, a one to many which works very well in Power Pivot and DAX. Then there is a Many to Many relationship, which can cause problems.
In this video we will look at three many to many relationship problems in Excels Power Pivot and how you can easily overcome them. The approach we will take is very systematic. We will build up our data model table by table. This way we can see how additional tables of data, that contain many to many relationships, can effect our pivot table formula. Then we will look at how the problems can be solved.
Check out our KZbin play list
• Learn Excel - Playlist