Forum Discussion
Multiple person names on single task
In Microsoft Planner, one task is assigned to multiple persons, but it shows only one person. I want to see the names of all assigned persons. Can you provide DAX for this requirement?
Hello Rajesh_8015
try this measure
Assigned Users =
CONCATENATEX(
VALUES(TaskAssignee[UserID]),
RELATED(Users[UserName]),
", "
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
6 Replies
- pankajnamekar25Super User
Hello Rajesh_8015
try this measure
Assigned Users =
CONCATENATEX(
VALUES(TaskAssignee[UserID]),
RELATED(Users[UserName]),
", "
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
- AnonymousNot applicable
Hi Rajesh_8015,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you want a way to find all the names of person who are assigned a certain task. As pankajnamekar25 already responded to your query, please go through it and check if solves your issue.
I would also take a moment to thank pankajnamekar25, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
- AnonymousNot applicable
Hi Rajesh_8015,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.- AnonymousNot applicable
Hi Rajesh_8015,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.
- Ashish_ExcelSolution Supplier
Hi,
Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.