Forum Discussion

Rajesh_8015's avatar
Rajesh_8015
New Member
1 year ago
Solved

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 | LinkedIn

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

6 Replies

  • Hello Rajesh_8015 

    try this measure

    Assigned Users =

    CONCATENATEX(

        VALUES(TaskAssignee[UserID]),

        RELATED(Users[UserName]),

        ", "

    )

    Thanks,
     Pankaj Namekar | LinkedIn

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

  • Anonymous's avatar
    Anonymous
    Not 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 Team

     

    If this post helps then please mark it as a solution, so that other members find it more quickly.

    Thank you.

    • Anonymous's avatar
      Anonymous
      Not 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.

      • Anonymous's avatar
        Anonymous
        Not 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_Excel's avatar
    Ashish_Excel
    Solution 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.