DAX NEW Column to join values by comma

[Anonymous]

Hello,

I have a table with the following format:

PK1, Value1

PK1, Value2

PK2, Value1

PK2, Value3

How to create in DAX a column with all the distict values separated by comma that are assoiated with the pk?

PK1, Value1, "Value1,Value2"

PK1, Value2, "Value1,Value2"

PK2, Value1, "Value1,Value3"

PK2, Value3, "Value1,Value3"

PK3, Value4, "Value4"

[Anonymous]

thank you, it works

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can try this code to create a calculated column.

Combine by PK =
CONCATENATEX (
    FILTER ( 'Table', 'Table'[PK] = EARLIER ( 'Table'[PK] ) ),
    [Value],
    ","
)

Result is as below.

Best Regards,
Rico Zhou

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