topic Re: DAX column in DAX Commands and Tips

DAX column

prashantg364 — Sun, 16 Jul 2023 11:32:00 GMT

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

Re: DAX column

lbendlin — Tue, 18 Jul 2023 00:45:23 GMT

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 ?

Re: DAX column

Anonymous — Wed, 19 Jul 2023 09:07:04 GMT

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.