Forum Discussion
Solved
Bridge Table - Create new table from two columns in different tables
Hi all, I have two tables and I would like to create a new table based on two columns. one column from each table. For instance, Table 1 has Contact ID column and Table 2 has BC # column. I w...
ysherriff so you want the cross join of them?
If yes than it's:
Table = CROSSJOIN(DISTINCT('Table1'[Contact ID]),DISTINCT('Table2'[BC #])
Solved.
Utilized this website to create a bridge table.
How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive