Forum Discussion

prashantg364's avatar
prashantg364
Icon for Helper II rankHelper II
3 years ago
Solved

DAX column

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 existi...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.