Forum Discussion
Bridge Table to bypass Many-to-Many Problem
Hello community, I am hoping you can help me. I have one column in Table A with part numbers, all unique except for a string of 0's afterwards. Those zero's are there because in the source data t...
Hi Anonymous ,
Please check if this is what you want:
1. Create a calculated table.
Bridge Table = DISTINCT ( UNION ( VALUES ( 'Table A'[Part Numbers] ), VALUES ( 'Table B'[Part Numbers] ) ) )2. Create relationships.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
In Power Query, Create new tables from each by referencing them, remove all columns except the relevant, append both new tables, remove duplicates, load and create the relationships
In Power Query, Create new tables from each by referencing them, remove all columns except the relevant, append both new tables, remove duplicates, load and create the relationships
Hi ImkeF - Since both Table A and B contain duplicates... the bridge table would display all part numbers and the one 0 with no duplicates.
That way Table A can have a relationship with Bridge table and,
Table B can have a relationship with the Bridge Table.
hi PaulDBrown I will try that, thanks!
- Anonymous
Before you append the new tables, make sure both columns have the same name (sorry, I forgot to mention that)