My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

DAX on PowerPivot: Lookup Results 1st, 2nd, 3rd etc.|Power Pivot|Excel Forum|My Online Training Hub

You are here: Home / DAX on PowerPivot: Lookup Results 1st, 2nd, 3rd etc.|Power Pivot|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
DAX on PowerPivot: Lookup Results 1st, 2nd, 3rd etc.
Avatar
Nawaf H H AlTaher
Riyadh, Saudi Arabia
Member
Members
Level 0
Forum Posts: 18
Member Since:
June 24, 2020
sp_UserOfflineSmall Offline
1
May 5, 2023 - 12:20 am
sp_Permalink sp_Print

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!

Avatar
Catalin Bombea
Iasi, Romania
Admin
Level 10
Forum Posts: 1824
Member Since:
November 8, 2013
sp_UserOfflineSmall Offline
2
May 11, 2023 - 1:07 pm
sp_Permalink sp_Print sp_EditHistory

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.pngImage Enlarger

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.

sp_PlupAttachments Attachments
sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Magnolia Stellata
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 216
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Melanie Ford
Isaac Felbah
Adele Glover
Hitesh Asrani
Rohan Abraham
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Forum Stats:
Groups: 3
Forums: 24
Topics: 6356
Posts: 27793

 

Member Stats:
Guest Posters: 49
Members: 32324
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen