CONCATENATEX
Concatenates the result of an expression evaluated for each row in a table.
Syntax
CONCATENATEX(<table>, <expression>, [delimiter])
Parameters
| Term | Definition |
|---|---|
| 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.
Remarks
This function takes as its first argument a table or an expression that returns a table. The second argument is a column that contains the values you want to concatenate, or an expression that returns a value.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
Employees table
| FirstName | LastName |
|---|---|
| Alan | Brewer |
| Michael | Blythe |
The following formula:
CONCATENATEX(Employees, [FirstName] & " " & [LastName], ",")
Returns:
"Alan Brewer, Michael Blythe"