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