Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Combine two columns from two tables

Hi all

I have two different query tables which both have an email address column. One table has 16m records, the other has 12m records. I want to create a new query table which has the unique email addresses from the two tables. The tables have other columns but I just want to combine the two email address columns in another table. Any help would be great. Thanks. Mike
1 ACCEPTED SOLUTION
Anonymous
Not applicable

I'm sure there is a power query / M way of doing this, but I'm a dax nerd.  I'd use "Calculate Table" with

NewTable = UNION(DISTINCT(Table1[Email]), DISTINCT(Table2[Email])

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

I'm sure there is a power query / M way of doing this, but I'm a dax nerd.  I'd use "Calculate Table" with

NewTable = UNION(DISTINCT(Table1[Email]), DISTINCT(Table2[Email])

Anonymous
Not applicable

@Anonymous Thanks !!. This worked for me .Thank you

Anonymous
Not applicable

Think I need to become a DAX nerd! Thanks scottsen, worked a treat!

 

I just added another DISTINCT before UNION to make sure only one email address was returned if the same email address was in both tables.

 

Thanks!

 

Mike

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!