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

CONCATENATEX ( <Table>, <Expression> [, <Delimiter>] [, <OrderBy_Expression> [, [<Order>] [, <OrderBy_Expression> [, [<Order>] [, … ] ] ] ] ] )

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

Scalar A single string value.

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:

CONCATENATE

Last update: Feb 6, 2019 » Contribute » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/concatenatex-function-dax