Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Concatenate values having a same category

Hello,    I would like to concatenate values having the same category by "-"   Input :  Category Values A red A orange A yellow B yellow C green   Expected Output : ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    You could create a calculated column:

    Column = CONCATENATEX(FILTER('Table','Table'[Category]=EARLIER('Table'[Category])),'Table'[Values],"-")

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

You could create a calculated column:

Column = CONCATENATEX(FILTER('Table','Table'[Category]=EARLIER('Table'[Category])),'Table'[Values],"-")

 

Best Regards,

Jay