Forum Discussion
LOOKUPVALUE with multiple results
Hello Ashish,
read your post and was trying to implement as described but I received some error messages
I want to use your code to expand a table 1 of various columns (picture below shows only two columns for simplicity) with another table 2 through the common column "sector" . From table 2, I want to carry 3 columns (application, Units, Price) into the new table "desired result". I tried the following code in a new table, but was not succesfull:
Source = Table.NestedJoin(#"table1", {"Sector"}, #"table2",{"Sector"},#"result",JoinKind.LeftOuter)
Hope you can help. Thanks in advance!
Share some data to work with and show the expected result clearly.
thanks Ashish for getting back to me so fast, please see in link below an xls sheet with table 1, table 2 and the desired result table.
What I want to accomplish is to get power bi to create a new table using table 1 and table 2 with the common column "sector", so basically expand table 1 with table 2.
I think that's exactly what your code is supposed to do but I think I'm doing something wrong - unfortunately I'm new to BI and still need to learn 😉
Thank you so much.