Forum Discussion
Solved
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 tab...
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
Tahreem24
Super User
Super Usersurajyadav484 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