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 apprecia...
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.

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.

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

    Hi Lachlanpap -  "concet" is the table name i have used to derive the above logic.

     

    Thank you