Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
surajyadav484
Regular Visitor

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: 

surajyadav484_0-1685082522712.png

Table 2:

surajyadav484_1-1685082593798.png

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.

1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

@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

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

1 REPLY 1
Tahreem24
Super User
Super User

@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

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors