I helped a couple of people this week on the topic of creating multiple relationships between two tables. There is not a lot of information on this topic on the web so I thought I would write about it here.
Power Pivot is not the Same a Relational DB
For those of you that have used SQL Server or MS Access, you will be aware that when using these relational database programs, it is perfectly acceptable to create multiple relationships between tables. Power Pivot is not a relational database but a reporting database. It needs data structured in a certain way to optimise the speedy process of finding the data needed and displaying it in your reports. Microsoft had to make compromises in the design to make this process fast, and one compromise is that there can only be 1 active relationship between 2 tables Read more...
