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...
v-kelly-msft
Community Support
Community SupportHi 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,
Kelly
Kelly
Did 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 |