Forum Discussion
Incomplete/incorrect relations between two tables in Excel Power Pivot Data Model
Greetings Excel Community - this is my first posting here.. Seeking expertise in building a Power Pivot Table leveraging two different tables of data loaded into the data model using the latest subs...
Mark_Everett You can't have "many-to-many" relationships in the DM. In the attached file I grouped the Billed and Logged tables by RO# before merging (and load back to Excel) or loading them Into the DM (to create a pivot table). See if this resolves your problem.