CONCATENATEX
Concatenates the result of an expression evaluated for each row in a table.
Syntax
CONCATENATEX(<table>, <expression>[, <delimiter> [, <orderBy_expression> [, <order>]]...])
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 table. |
| delimiter | (Optional) A separator to use during concatenation. |
| orderBy_expression | (Optional) Any DAX expression where the result value is used to sort the concatenated values in the output string. It is evaluated for each row of table. |
| order | (Optional) A value that specifies how to sort orderBy_expression values, ascending or descending. |
The optional order parameter accepts the following values:
| Value | Alternate Values | Description |
|---|---|---|
| 0 (zero) | FALSE, DESC | Sorts in descending order of values of orderBy_expression. This is the default value when the order parameter is omitted. |
| 1 | TRUE, ASC | Sorts in ascending order of values of orderBy_expression. |
Return value
A concatenated 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.
Concatenated values are not necessarily sorted in any particular order, unless orderBy_expression is specified.
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"