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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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