Forum Discussion

Lachlanpap's avatar
Lachlanpap
Frequent Visitor
2 years ago
Solved

DAX concatenate based on matching value

I would like to create a column that concatenates the 'Name' column with a comma to seperate names if the 'SessionId' column matches. 

 

I'm not sure if this is possible? Any help would be appreciated. Thanks

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Lachlanpap ,

    The Concet in rajendraongole1's expression is a table name, you can replace it with your own table name, and you can also refer to the following expression.

    Column = CONCATENATEX(FILTER('Table',[SessionId]=EARLIER('Table'[SessionId])),[Name],",")

    Output

    If the solutions rajendraongole1 and I offered help you, you can consider to accept them as solutions so that more user can refer to.

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    2 years ago

    Hi Lachlanpap - create below calcualted column to get the concatenation based on session id columns.

    ConcatenatedNames =
    VAR CurrentSessionId = Concet[SessionId]
    RETURN
    CALCULATE(
        CONCATENATEX(
            ALL(Concet),
            IF(Concet[SessionId] = CurrentSessionId, Concet[Name], BLANK()),
            ", "
        )
    )

     

    Check it and let know.

     

     

    • Lachlanpap's avatar
      Lachlanpap
      Frequent Visitor
      2 years ago

      Thanks rajendragongole1. Appreciate your assistance. The calculated column doesn't seem to work. I understand the concept of a variable but can you please explain what 'concet' is? This doesn't seem to be a DAX expression. Thanks, Lachlan

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Lachlanpap ,

        The Concet in rajendraongole1's expression is a table name, you can replace it with your own table name, and you can also refer to the following expression.

        Column = CONCATENATEX(FILTER('Table',[SessionId]=EARLIER('Table'[SessionId])),[Name],",")

        Output

        If the solutions rajendraongole1 and I offered help you, you can consider to accept them as solutions so that more user can refer to.

         

        Best Regards!

        Yolo Zhu

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Lachlanpap's avatar
    Lachlanpap
    Frequent Visitor
    2 years ago

    Thanks Yolo Zhu. Looks like there is a few ways to solve the same problem. I ended up using your expression Yolo. Thank you for introducing me to the EARLIER function. Thanks rajendraongole1 for your help also.