Bridge Table - Create new table from two columns in different tables

[ysherriff]

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 would like to make Table 3 that has Contact ID and BC column in one table.

I cannot use merge because these table do not have a relationship with each other. I am trying to create a bridge table for data modeling relationship purpose

[SpartaBI · Accepted solution]

@ysherriff so you want the cross join of them?
If yes than it's:
Table = CROSSJOIN(DISTINCT('Table1'[Contact ID]),DISTINCT('Table2'[BC #])
 

Showcase Report – Contoso By SpartaBI

      

[ysherriff]

Solved.

Utilized this website to create a bridge table.

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive

[SpartaBI · Accepted solution]

@ysherriff Great 🙂

[SpartaBI · Accepted solution]

@ysherriff so you want the cross join of them?
If yes than it's:
Table = CROSSJOIN(DISTINCT('Table1'[Contact ID]),DISTINCT('Table2'[BC #])
 

Showcase Report – Contoso By SpartaBI