Forum Discussion
DAX NEW Column to join values by comma
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"
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.