Forum Discussion

ThiemenSiemensm's avatar
ThiemenSiemensm
Frequent Visitor
3 years ago

Vertical lookup

Good morning everybody,   I have a vertical loopup question using power query. I have two columns in power query, one containing a number, and another containing rows of nulls and lists. The lists ...
Tips and Tricks
AlB's avatar
AlB
Community Champion
3 years ago

Hi ThiemenSiemensm 

I don't quite understand what you want to do. Can you elaborate, provide another example? Best if you can share some sample data (in text-tabular format rather than a screen cap or ideally the pbix) and show the expected result

 

 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

   

ThiemenSiemensm's avatar
ThiemenSiemensm
Frequent Visitor
3 years ago

Hi,

 

I hope the two screenshots below give enough information along with my explanation. 

 

The first screenshot is the column containing lists of values, which has been expanded in the second screenshot, so that list contains [520;620;690;730]. I want to look for that values in the column 'RijNr.' and the new column must contain the value 'Omschrijving'. So all the values for which 'RijNr.' is in [520;620;690;730] has new column value TOTAL PRODUCTION COST. Just like a lookup in Excel, see example shown below. Hope this clarifies things!