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
In the end, I merged my tables. This is the best way indeed 🙂
IAM , Thanks for the update.