CONCATENATEX Concatenates the result of an expression evaluated for each row in a table.


CONCATENATEX(table, expression, [delimiter])


table – The table containing the rows for which the expression will be evaluated.
expression – The expression to be evaluated for each row of the table.
delimiter – (optional) A separator to use during concatenation.

Return Value

A text string.

Reference Data

DAX Functions / Text Functions / CONCATENATEX