Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    Anonymous
    Not applicable
    9 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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