Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |