Power BI

[surajyadav484]

I have two tables. both tables contain a column named 'Company name'.  I want to copy the unique data from both the columns of two different tables and paste it into another column (may be in 3rd table).

Table 1: 

Table 2:

New column of 3rd table should contain unique records from above two columns. How can I achieve this? Please help me. Thanks!

Note: I want to implement venn diagram in power bi to show common companies hence I want to prepare data in that format.

[Tahreem24 · Accepted solution]

@surajyadav484 You can achieve your solution using 2 ways.

Solution1: Using UNION DAX you can combine two tables with same structure 

https://learn.microsoft.com/en-us/dax/union-function-dax

Solution2: Using Append option using PowerQuery(Transform Data) 

https://learn.microsoft.com/en-us/power-query/append-queries