Creating 1 list of unique items from 2 tables

[Anonymous]

Hello guys!

I have been struggling for a day or two trying to combine data from 2 columns that are in 2 different tables (2 excel files). 
I'm pretty new to Power BI, please be gentle. I did try searching for solution, but most of them offered the solution for merging columns inside one table.

Two columns contain country names, I need to take values from "column 1" in one table and combine with "column 2" in another table (So, if "column 1" had 100 rows and "column 2" had 100 rows - I should end up with 200 rows) and delete duplicates so only unique values are left.

I hope it is clear what I'm trying to do.

Any help is greatly appreciated!

Thank you in advance!

[amitchandak · Accepted solution]

@Anonymous , A new table in DAX

Country = distinct(union(distinct(Table1[Country]),distinct(Table2[Country])))

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

[Anonymous]

Awesome!

Thank you for the help!