DAX column

[prashantg364]

I am having data as per the below input table.

Now I want to create a new column where if the cluster name is the same then I want to concatenate the band else result in band available in the existing column. refer output table to understand my requirement.

pls help

input table

Circle	Cluster	Band	17_KPIs
BR	BR-ARRH-0001	700	12
BR	BR-ARRH-0001	3500	10
BR	BR-ARRH-0002	700	15
BR	BR-BGLP-0003	3500	10
BR	BR-BGLP-0004	700	15
BR	BR-BGLP-0004	3500	16

Output table

Circle	Cluster	Band	17_KPIs	New column
BR	BR-ARRH-0001	700	12	700
BR	BR-ARRH-0001	3500	10	700,3500
BR	BR-ARRH-0002	700	15	700,3500
BR	BR-BGLP-0003	3500	10	3500
BR	BR-BGLP-0004	700	15	700,3500
BR	BR-BGLP-0004	3500	16	700,3500

[Anonymous · Accepted solution]

Hi @prashantg364 ,

I suggest you to try code as below to create a calculated column.

New column = CONCATENATEX(FILTER('Table','Table'[Cluster] = EARLIER('Table'[Cluster])),'Table'[Band],",")

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.

[lbendlin]

There is no sort oder in Power BI. How are you identifying the "first" entry per cluster?  or should all rows in your expected result say 700,3500 ?