Forum Discussion

IAM's avatar
IAM
Helper III
4 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

michaelu1's avatar
michaelu1
Advocate II
1 year ago

Anonymous  and amitchandak 

Is there a preference as far as optimizing my query as to which method I use?

I need a single column of data from a different query. Is it more optimal to merge tables and then only expand the column that I need or do this list lookup?

michaelu1's avatar
michaelu1
Advocate II
1 year ago

I can tell you that I just tried it and after trying to load, it sat spinning at the evaluating stage for nearly an hour..

 

I ended up canceling and doing the merge instead which went right away.