Forum Discussion
Many to Many Relatioship
Hi Anonymous ,
You'd better ceate a bridge table when use many to many relationship,such as below:
Here is the reference. https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships
Kelly
Hi v-kelly-msft.
What you are referring to is not really Many-to-Many. It's an example of a granularity problem.
So it's not the pattern of M2M:
Table1 1:* Bridge *:1 Table2
but a completely different one:
Table1 *:1 DistinctValues 1:* Table2.
This is not Many-to-Many. It's a granularity issue and can be solved easily without the middle table. You can join directly the fields from Table1 to Table2. You then get something that's known as a weak relationship and is enough to solve the problem.
Best
D- Hello Kelly
I have created bridge table but it didn't work as expectedHi Anonymous ，
I made 2 sample tables which have many to many relationship,see below:
Would you pls advise me what is your expected output?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!Hi v-kelly-msft
Thanks for helping, i will give you below data sample please refer,
error table sample
DUPLICATE FIELD CUSTODIAN CLIENT CREATE DATE Duplicates GBS CDM Atlanta North America 4/1/2020 Street GBS CDM Atlanta North America 3/1/2020 Street GBS CDM Atlanta North America 3/1/2020 Name1 GBS CDM Atlanta North America 3/1/2020 Name1 GBS CDM Atlanta North America 3/1/2020 Client Record Table
Group Type Group Name Record Count CREATE DATE Client Corporate 3 4/1/2019 Client CPS EEA 3 4/1/2019 Client CPS Asia 2 4/1/2019 Client CPS EEA 1 3/1/2020 Client CPS Latin America 4 4/1/2019 Client CPS Latin America 2 4/1/2019 Client CPS Latin America 2 4/1/2019 Client Corporate 1 9/1/2019 Client Corporate 1 9/1/2019 Client Corporate 1 1/1/2020 Client Corporate 1 3/1/2020 Client Corporate 1 3/1/2020 Client CPS Asia 2 4/1/2019 Client CPS Asia 1 4/1/2019