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...
Hi Darlove
Please see this screeshot , this is actual table need to connect
amitchandak
Super User
Super UserAnonymous , 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