topic Re: retrieve values from another table for multiple values in DAX Commands and Tips

retrieve values from another table for multiple values

jtpiazzamn — Thu, 19 May 2022 04:11:22 GMT

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

Re: retrieve values from another table for multiple values

tamerj1 — Thu, 19 May 2022 07:52:29 GMT

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.

Re: retrieve values from another table for multiple values

Anonymous — Wed, 25 May 2022 06:35:11 GMT

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