CONCATENATEX DAX Function (Text)
Evaluates expression for each row on the table, then return the concatenation of those values in a single string result, seperated by the specified delimiter.
Syntax
Parameter | Attributes | Description |
---|---|---|
Table Iterator |
The table containing the rows for which the expression will be evaluated. |
|
Expression Row Context |
The expression to be evaluated for each row of the table. |
|
Delimiter | Optional |
The delimiter to be concatenated with expression. |
OrderBy_Expression Row Context |
Optional Repeatable |
Expression to be used for sorting the table. |
Order | Optional Repeatable |
The order to be applied. 0/FALSE/DESC – descending; 1/TRUE/ASC – ascending. |
Return values
A text string with the concatenated values.
Remarks
This function iterates the rows in the table provided by the first argument and for each row it executes the expression provided in the second argument. All the expressions are concatenated using the separator provided as third argument.
Related functions
Other related functions are:
Last update: Dec 7, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/concatenatex-function-dax