Forum Discussion
Vlookup in Power Query Editor
Hi, How to use VLookup in Power Query Editor? I've pasted the DAX here but no luck. Any help on this?
Refer the below blog to achieve it in M query:
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
Or
You can duplicate your query and merge the two queries to get the desired columns.
Disable the load from the duplicate one to avoid performance issues
PC2790
Community Champion
Community ChampionRefer the below blog to achieve it in M query:
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
Or
You can duplicate your query and merge the two queries to get the desired columns.
Disable the load from the duplicate one to avoid performance issues
Thank you so much. You made my Day. 😎