Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jtpiazzamn
Helper I
Helper I

retrieve values from another table for multiple values

I have 2 tables - 

1) User List - has the following columns - ID#, First Name, Last Name

2) Reviewer List - has the following columns - Reviewer ID#, Submitter ID#, Submission Title

 

I want to add columns (a measure?) to the Reviewer List table which will be - 

Reviewer First Name, Reviewer Last Name (based on Reviewer ID#)

Submitter First Name, Submitter Last Name (based on Submitter ID#)

 

So based on the Reviewer ID - it will pull the name from the User List table, and the same with the Reviewer ID 

 

Thanks in advance! 

Jim

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @jtpiazzamn,

I think lookupvalue function should suitable for your requirement, you can use the current field id to lookup the user table records.

LOOKUPVALUE function (DAX) - DAX | Microsoft Docs

Regards,

Xiaoxin Sheng

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

HI @jtpiazzamn,

I think lookupvalue function should suitable for your requirement, you can use the current field id to lookup the user table records.

LOOKUPVALUE function (DAX) - DAX | Microsoft Docs

Regards,

Xiaoxin Sheng

tamerj1
Super User
Super User

Hi @jtpiazzamn 

you need to create a relationship between both tables using ID# and Reviewer ID# columns. I guess both are unique lists therefore the relationship will be one to one bidirectional relationship. 
Then you can create a table visual and have the columns from Reviewers table inserted in the table. 
create measures: example

SEKECTEDVALUE ( Users[First Name] ) and drag into the table visual. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.