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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.