Dear Mynda,
I have multiple tables containing mutual fields (columns of data) but in all cases the data appear as duplicates (many-to-many relationships) except for a single table where a single field consist of unique values (one-to-one). I therefore cannot create relationships between the "many-to-many" tables although I would like to create a report based on the data contained in these "many-to-many" data tables. Can you please help as I have read the following
- In a data model, table relationships can be one-to-one (each passenger has one boarding pass) or one-to-many (each flight has many passengers), but not many-to-many. Many-to-many relationships result in circular dependency errors, such as “A circular dependency was detected.” This error will occur if you make a direct connection between two tables that are many-to-many, or indirect connections (a chain of table relationships that are one-to-many within each relationship, but many-to-many when viewed end to end. Read more about Relationships between tables in a Data Model.
- https://support.office.com/en-us/article/Create-a-relationship-between-tables-in-Excel-fe1b6be7-1d85-4add-a629-8a3848820be3?ui=en-US&rs=en-US&ad=US
The last sentence bothers me because that is exactly what I want to achieve. I will appreciate your insights. Many thanks. Louis
Hi Louis,
First of all, thanks for using the forum. In future please post your course related questions in the Power Pivot Course Members forum, not the free Power Pivot forum.
To answer your question; it sounds like you have many fact tables. In session 6.07 I talk about this using the example of haivng tables for Actuals and Budget figures, both of which are fact tables. All you need to do is create a common dim table that you can use to create relationships between your multiple fact tables.
Please watch session 6.07 again as I think that should help you see what is required, and let me know if you get stuck/have more questions.
Kind regards,
Mynda
