Forum Discussion
Many to Many Relatioship
Hello All I'm Trying to create a report where i have two Table as Error Table and Client Record. Both table have Many to Many Relation and Both as cross Filter Drection . I have tried c...
Many-to-Many means having a bridge table from a dimension to a dimension. So, it's Dim1 1:* Bridge *:1 Dim2. The classic example of this is the association between accounts and customers. One account can have several owners and one owner can own several accounts. Therefore the structure is:
Account 1:* AccountToCustomerBridge *:1 Customer.
You do not have a bridge table in your picture.
Best
D
Account 1:* AccountToCustomerBridge *:1 Customer.
You do not have a bridge table in your picture.
Best
D
Hi Darlove
Please see this screeshot , this is actual table need to connect
- amitchandak
Super User
Anonymous , Your screenshot is not making it clear. Can you share sample data and sample output.
Are you able to join in the required column? Or do need to create a concatenated column.
Like New Key = [Key1] &"-"& [Key2]
Also, refer :
https://www.seerinteractive.com/blog/join-many-many-power-bi/
https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships
