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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
VanithaGovindan
New Member

Power Query - Match rows

Hi Team, 

 

I've a clarification . In VBA we are using matchrow. row Function . How to implement the same in power query .

There are 2 tables. Name it Table A and Table B.   Both the table has same columns  Example - Status. 

If in Table A , Eg the status of XXX - Open and in Table B- ths status of XXX - WIP/Closed. i need to update the status of the XXX without affecting other columns, Instead the column status of XXX should get changed to WIP/Closed .  Only if there are any change in the status from Table B , the data should get populated in Table A. so that other data remains same . 

 

Please advise 

 

Thanks 

Vanitha G 

1 ACCEPTED SOLUTION
aduguid
Super User
Super User

Sounds like you just need to merge the 2 queries. When you merge, you typically join two queries that are either within Excel or from an external data source. In addition, the Merge feature has an intuitive user interface to help you easily join two related tables. For an example of merging total sales from an order details query into a products table.

https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616...

View solution in original post

1 REPLY 1
aduguid
Super User
Super User

Sounds like you just need to merge the 2 queries. When you merge, you typically join two queries that are either within Excel or from an external data source. In addition, the Merge feature has an intuitive user interface to help you easily join two related tables. For an example of merging total sales from an order details query into a products table.

https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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