Forum Discussion
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...
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.
Use the GUI to do a merge. It walks you through it pretty well. Code by hand as a last resort unless you're comfortable self-describing as "a coder."