cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amar-Agnihotri
Helper II
Helper II

Copy column from one table to another table in power query in Power BI

I have 2 tables Table1 and Table2. In both the table there is no common column so that I could merge them . I created an index in both the tables. Now on the basis of index from table1 I want to copy a column to table2 so that i could perform merge operation on this column. The issue is how to copy column from table1 to table2 using power query ?

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

There's a menu item for that. Merge or Merge as new.

View solution in original post

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi  @Amar-Agnihotri ,

 

Can you directly merge the 2 tables by index columns?

vkellymsft_0-1628492401084.png

And you will see:

vkellymsft_1-1628492431789.png

You could check my sample .pbix file attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

lbendlin
Super User
Super User

There's a menu item for that. Merge or Merge as new.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors