CONCATENATEX Concatenates the result of an expression evaluated for each row in a table.
Syntax
CONCATENATEX(table, expression, [delimiter])
Parameters
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
https://docs.microsoft.com/en-us/dax/dax-function-reference