DaX or Power Query for creating new tables

[axecap]

I have a few tables that I'm joining together in the data pane of Power BI using Dax like this. I just want a table that starts with distinct emails from two different tables. 

new_table = DISTINCT(UNION(SUMMARIZE(Hubspot,Hubspot[hubspot_email]),SUMMARIZE(platform2,platform2[Partner email])))

 It seems to work fine but is this something I should be doing in Powerquery instead? Would it be faster, or just better practice? If so, how would you do it in PQ? 

Thanks!!

[axecap]

Thanks Pat, that is a nice simple way to do that in PQ instead.

[ppm1 · Accepted solution]

While what you've done is fine, one way to do it in the query editor:

1. Right click on one of your queries/tables and choose "Reference"

2. In that new query, select your Email column, right click and choose Remove Other Columns

3. Create a Reference query from your other table with email column

4. Do same as step 2 with it

5. Rename the Email column to exactly match (case sensitive) the one in step 2

6. Choose append and add the query from step 2

7. Remove Duplicates

8. Right click on the step 2 query and uncheck enable load

9. Name and load the combined email table

It's a lot of steps but they can be done quickly.

Pat