Forum Discussion
How to create multiple relationships between two tables (on separate columns)
Hello, I'm working on a report with multiple tables and multiple relationships between the tables. Want to know if it's possible to realize the following scenario. Let's say there is a table ...
Hi,
If you do not want to append the 2 tables then do this:
- Remove the relationship between the 2 tables
- Create a Category table and build a relationship from the Category columns of both tables to the category column of the new table
- Create a Calendar table and build relationships as mentioned in point 2 above
Hope this helps.
amitchandak
Super User
Super UserAnonymous , In this case, you have to create a common date, category, and group tables. category and group may be on one table.
Refer to this file how to create a common dimension from two tables
https://www.dropbox.com/s/op9lb78w9utdonz/Distinct%20from%20two%20Tables.pbix?dl=0
Also, refer
https://www.sqlbi.com/blog/marco/2017/10/02/why-data-modeling-is-important-in-powerbi/
https://www.seerinteractive.com/blog/join-many-many-power-bi/