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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.