Forum Discussion
Solved
Power Query LookUp in another table
Hi all, I have found so many (solved) posts, but I haven't managed to translate it to my situation, so I hope someone will help me. In table IW38 I want to add a column M_Planner That new...
Hi IAM ,
You can add a custom column as below in the table IW38 in Power Query Editor, please find the details in the attachment.
= Table.AddColumn(#"Changed Type", "M_Planner", each PlGrp[Planner]{List.PositionOf(PlGrp[Code],[Plannergroup])})In addition, you can refer the following blog to achieve it, there are two methods(merge method and add a custom column method) include in this blog.
VLOOKUP in Power Query Using List Functions
Merge method
Add a custom column method
Best Regards
IAM , lookup in power query means merge the tables
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
Merge: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
In the end, I merged my tables. This is the best way indeed 🙂
IAM , Thanks for the update.