| description | title |
|---|---|
Learn more about: CONCATENATEX |
CONCATENATEX function (DAX) | Microsoft Docs |
[!INCLUDEapplies-to-measures-columns-tables-visual-calculations]
Concatenates the result of an expression evaluated for each row in a table.
CONCATENATEX(<table>, <expression>[, <delimiter> [, <orderBy_expression> [, <order>]]...])
| 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. |
A concatenated string.
-
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.
-
[!INCLUDE function-not-supported-in-directquery-mode]
Employees table
| FirstName | LastName |
|---|---|
| Alan | Brewer |
| Michael | Blythe |
The following formula:
= CONCATENATEX(Employees, [FirstName] & " " & [LastName], ",")
Returns:
"Alan Brewer, Michael Blythe"