Forum Discussion
DAX Help with Lookup for multiple users
Thanks for your assistance, but I found a different solution. AssignedTo is also found under FieldValuesAsText. I selected the fields I needed and it is already available. No function needed.
If I do not have a relationship between the tables, I get this error:
I created a relationship with ApprovalSentToID as well as FinalApproverID to ID in the User Information List
It then works, but I get the same results and it is not pulling in anything for both approvers. The second row should have 2 approver names.
Here is what the data looks like:
ApprovalSentToID:
User table:
I changed the number from 3 to 15 and I get these results
Now it shows the full name, but when there is a single approver, it lists it twice. When there is multiple, still nothing.
Another Comment, I don't think I can split the columns, because I will not know if there is one approver, or 10, the approver list is dynamic based upon another list for Department in SharePoint.
Could you try this then?
Approval Sent To =
IF (
IFERROR ( SEARCH ( ",", [ApprovalSentToId] ), -1 ) >= 0,
LEFT ( RELATED ( 'User Information List'[Title] ), 3 ) & ", "
& RIGHT ( RELATED ( 'User Information List'[Title] ), 3 ),
LEFT ( RELATED ( 'User Information List'[Title] ), 3 )
)Thanks for your assistance, but I found a different solution. AssignedTo is also found under FieldValuesAsText. I selected the fields I needed and it is already available. No function needed.