Concatenate values having a same category

[Anonymous]

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 : 

Category	Values
A	red - orange - yellow
B	yellow
C	green

Thanks in advance

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

You could create a calculated column:

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

Best Regards,

Jay

[ribisht17]

@Anonymous 

This is explained here

Pre Concatenate List of Values in Power BI using Power Query - RADACAD

Regards,

Ritesh

[amitchandak]

@Anonymous , Create a new measure and use that with Category

concatenatex(Table, [Values], " - ")

refer video Power BI Abstract Thesis Episode 72: Concatenate Text- Measure, DAX Table, and Power Query Table

https://www.youtube.com/watch?v=xAh3tz1qo24