Forum Discussion
Vlookup in Power Query Editor
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
Hi,
I need to use it here only so that I can unpivot the columns for my Dynamic Diemension logics. I can achive it from the Desktop but I can't do the unpivotting.
Is it possible to get my desired coloum from another table using M Query?
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. 😎