Forum Discussion

SP3007's avatar
SP3007
Frequent Visitor
2 years ago
Solved

Power Query Lookup to another table

Hello, I need some help please!   I need to add a new column to my table. It needs to bring back a value by looking up a column against another table. ie - column it needs to look upto is: CCA1 T...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi SP3007 

    You can change the code to the following.

    = Table.AddColumn(#"5 - Added CCA1 Column", "OrgStructServiceID", each List.Min(Table.SelectRows(Helper_CCA1_Service,(x)=>x[CCA1]=[CCA1])[OrgStructServID]))

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AlienSx's avatar
AlienSx
Super User
2 years ago

Hello, SP3007 those brackets... Why don't you Table.NestedJoin your table with helper? 

step
  = Table.AddColumn(
    #"5 - Added CCA1 Column",
    "OrgStructServiceID",
    each
      let
        CCA1 = [CCA1]
      in
        Table.SelectRows(
          Helper_CCA1_Service,
          each [CCA1] = CCA1
        ){0}[OrgStructServID],
    type number
  )