Many to Many Join in Power Bi

Hi Chirag_Sidana,

In the below picture showing the relationships, I have 2 tables which are joined by Data. But here the problem is both Table1 and Table2 have Multiple entries of same Dates resulting in a many-to-many relationship

To handle this, a new table Table1 (2) is introduced. This is the bridge table in this relationship. This table will have distinct entries of Dates from one of the tables. (Usually the table which has more dates in it). using this you can now connect Table1 with Table2

 Hope it is clear!!!

Regards,

Thejeswar

Hi Chirag_Sidana,

The solution provided by Thejeswar is correct, however is a smal catch that is the details of the second table you need to active the croos filter in both sides of the relationship.

Check the PBIX file in attach.

Regards,

MFelix