Forum Discussion
Solved
DAX Help with Lookup for multiple users
I have a Sharepoint list that I am creating a PBI report for. This sharepoint list will have one or more IDs for an approval workflow. I want to show who the Approval request went to using the Appr...
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.
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.