June 24, 2020
Hello friends, Hope all is well!
Sorry to bother you, I need a DAX formula please. Please open the attachment.
I have 2 sheets in the Power Pivot Data Model. Sheet "Look" looks for the ID from Sheet "DB" and returns the names.
all the matches, 1st match, 2nd, 3rd, 4th and 5th.
Meaning please have column "LookUp Results" filled with the names from sheet "DB".
I tried formula LookUpValue but it would not work
Thank you Very Much in Advance!
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013
If you just want to see the results for a specific ID, you can just use a pivot table and a slicer for ID:
If you want to process all the entries for a specific ID, you can use in another function the RELATEDTABLE DAX function, but you can't use it to just return results in sheet, that's what pivot tables are.
In the pivot table ID column filter, you can search for partial strings as well.