Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
@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
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |