cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ysherriff
Helper I
Helper I

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 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

2 ACCEPTED SOLUTIONS
SpartaBI
Community Champion
Community Champion

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


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

View solution in original post

SpartaBI
Community Champion
Community Champion

3 REPLIES 3
ysherriff
Helper I
Helper I

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
Community Champion
Community Champion

@ysherriff Great 🙂

SpartaBI
Community Champion
Community Champion

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


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors