Forum Discussion
Solved
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 a...
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
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.