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.

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.