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
5 years ago

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