DAX concatenate based on matching value

[Lachlanpap]

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

[Lachlanpap]

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. 

[rajendraongole1]

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]

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

[rajendraongole1]

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

Thank you

[Anonymous · Accepted solution]

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.