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.
