Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.