Forum Discussion
LOOKUPVALUE with multiple results
Super UserShare 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.
- Ashish_Mathur
Ashish, you literally saved my life!! Thank you so much , works like a charm!
- Ashish_Mathur
You are welcome. If my previous reply helped, please mark that reply as Answer.
Ashish, I tried, it only gives me the option "mark as new" - do you know where I find the link "mark as answer" and I will gladly do it...sorry , still new here 😉