Forum Discussion
Power BI
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.
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
1 Reply
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