Forum

DAX on PowerPivot: ...
 
Notifications
Clear all

DAX on PowerPivot: Lookup Results 1st, 2nd, 3rd etc.

2 Posts
2 Users
0 Reactions
123 Views
(@countryfan_nt)
Posts: 18
Eminent Member
Topic starter
 

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!

 
Posted : 05/05/2023 10:20 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi Nawaf,

If you just want to see the results for a specific ID, you can just use a pivot table and a slicer for ID:

image_2023-05-11_060657852.png

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.

 
Posted : 11/05/2023 11:07 pm
Share: