Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
Solved! Go to Solution.
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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
8 | |
8 | |
7 |
User | Count |
---|---|
17 | |
13 | |
7 | |
6 | |
6 |