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 : 

CategoryValues
Ared
Aorange
Ayellow
Byellow
Cgreen

 

Expected Output : 

 

CategoryValues
Ared - orange - yellow
Byellow
Cgreen

 

Thanks in advance

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

3 Replies