topic Re: DAX NEW Column to join values by comma in Developer

DAX NEW Column to join values by comma

Anonymous — Wed, 14 Dec 2022 19:27:07 GMT

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 — Thu, 15 Dec 2022 02:14:54 GMT

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.

Anonymous — Thu, 15 Dec 2022 11:37:34 GMT

thank you, it works