Forum Discussion
how to combine text in multiple rows- DAX
I have a table which contains employeess' self-evaluation (column "Achievement"). Is there a way to filter the data by employee and combine them into one measure?
If you just want to combine all rows into a single text measure, you can use concatonatex with a pattern like this.
CONCATENATEX(filteredTable,filteredTable[Acheivement],", ")
the filtered table could be done in different ways, including just passing the table name and adding the employees name into the rows section of a matrix.
MattAllington
Community Champion
Community ChampionIf you just want to combine all rows into a single text measure, you can use concatonatex with a pattern like this.
CONCATENATEX(filteredTable,filteredTable[Acheivement],", ")
the filtered table could be done in different ways, including just passing the table name and adding the employees name into the rows section of a matrix.
Thank you! That works perfectly.