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"