Forum Discussion
vso identity fields converted to weird text strings
Thank you!
Unfortunately I had several fields that all needed this matching so I've created columns using the LOOKUPVALUE function. Works like a charm!
Assigned To = LOOKUPVALUE(Users[UserName],Users[UserSK],WorkItems[AssignedToUserSK])
Catalizt wrote:
Yes!
I found the "Users" table and have brought it in.
I think the next thing to do is create calculated columns in my original table which contain the related value.
Example:
Assigned to = (RELATED('Users'[UserName]))
Is there a better way?
So I think the assignment table and user tables has a proper many:one relationship.
Besides creating a calculated column, you can do nothing. Then in a chart, like table chart, drag some fields from assignment table and also the name from user table, the relationship would find the related username.
Or you can create some measure just like
Measure =
CALCULATE (
SUM ( assigment[value] ),
FILTER ( assigment, RELATED ( user[username] ) = "name1" )
)
Thank you!
Unfortunately I had several fields that all needed this matching so I've created columns using the LOOKUPVALUE function. Works like a charm!
Assigned To = LOOKUPVALUE(Users[UserName],Users[UserSK],WorkItems[AssignedToUserSK])