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.
Hi SP3007
Can you send a little bit of the sample data in the two tables, because if the data IDs in the two tables are the same, it should not return a null value
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.
Your solution worked! Thank you. My data was wrong.
Thank you