Forum Discussion
Excel VLOOKUP against Power BI entity
You can make an Excel table into which you paste your 10 search items, let's say 10 Account Numbers. Use get data from table or range to add this table to power query, and then make it a list. Use that list in a Table.SelectRows(PriorStepOrTableName, each List.Contains(List.Buffer(NameOfYourUpdatedList), [Account Number]))
Assuming that you'll be loading the resulting table to an Excel sheet, you can just update your list in Excel, then just click Refresh all.
--Nate
You can make an Excel table into which you paste your 10 search items, let's say 10 Account Numbers. Use get data from table or range to add this table to power query, and then make it a list. Use that list in a Table.SelectRows(PriorStepOrTableName, each List.Contains(List.Buffer(NameOfYourUpdatedList), [Account Number]))
Assuming that you'll be loading the resulting table to an Excel sheet, you can just update your list in Excel, then just click Refresh all.
--Nate
Awesome solution! Thanks a lot!
