Solved: Concatenate values having a same category

Anonymous · ‎05-18-2022

Hello,

I would like to concatenate values having the same category by "-"

Input :

Expected Output :

Thanks in advance

v-jayw-msft · ‎05-23-2022

Hi @Anonymous ,

You could create a calculated column:

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

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

v-jayw-msft · ‎05-23-2022

Hi @Anonymous ,

You could create a calculated column:

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

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

ribisht17 · ‎05-18-2022

@Anonymous

This is explained here

Regards,

Ritesh

amitchandak · ‎05-18-2022

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Concatenate values having a same category