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 By Expression |
The expression to be evaluated for each row of the table. |
|
| Delimiter | Optional |
The delimiter to be concatenated with expression. |
|
OrderBy_Expression Row Context By Expression |
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. The result is BLANK when Table has no rows.
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.
The default order is ASC (ascending) when OrderBy_Expression argument is present and the corresponding Order argument is not specified.
If the OrderBy_Expression argument is not specified, the items in Table can be evaluated in any order, returning a string that does not reflect any existing physical order in the source data.
Delimiter is optional. Without Delimiter, CONCATENATEX joins the values with no separator. Delimiter is not evaluated in the row context of Table, so it cannot use the columns of Table.
CONCATENATEX returns BLANK when Table is empty. A BLANK value of Expression becomes an empty string, but CONCATENATEX still adds the delimiter. For example, CONCATENATEX ( { 1, BLANK (), 3 }, [Value], “,” ) returns “1,,3”. To skip the BLANK values, remove them from Table, for example with FILTER.
You can use more than one OrderBy_Expression. CONCATENATEX sorts by the first OrderBy_Expression, then by the next one when the values are equal. Each Order argument applies to the OrderBy_Expression before it. Order accepts ASC, DESC, TRUE, FALSE, 1, and 0.
» 1 related function
Examples
-- CONCATENATEX is an iterator that produces the concatenation
-- of expressions evaluated during the iteration.
-- You provide the expression, a separator and optional
-- sorting expressions.
EVALUATE
ADDCOLUMNS (
VALUES ( 'Product'[Category] ),
"Category colors",
CONCATENATEX (
CALCULATETABLE ( VALUES ( 'Product'[Color] ) ),
Product[Color],
", ", -- Separator (optional)
Product[Color], -- Sorting expression (optional)
ASC -- Sorting direction (optional)
)
)
| Category | Category colors |
|---|---|
| Audio | Black, Blue, Green, Orange, Pink, Purple, Red, Silver, White, Yellow |
| TV and Video | Black, Brown, Silver, White |
| Computers | Black, Blue, Brown, Gold, Green, Grey, Orange, Pink, Red, Silver, White, Yellow |
| Cameras and camcorders | Azure, Black, Blue, Gold, Green, Grey, Orange, Pink, Purple, Red, Silver, Silver Grey, White, Yellow |
| Cell phones | Black, Gold, Grey, Pink, Red, Silver, Transparent, White |
| Music, Movies and Audio Books | Black, Blue, Gold, Grey, Red, Silver, White, Yellow |
| Games and Toys | Black, Blue, Gold, Green, Grey, Pink, Purple, Red, Silver, White, Yellow |
| Home Appliances | Black, Blue, Brown, Gold, Green, Grey, Orange, Pink, Purple, Red, Silver, White, Yellow |
Related articles
Learn more about CONCATENATEX in the following articles:
-
Displaying Nth Element in DAX
This article describes how to create a measure displaying the name or value of an element that has a specific ranking, with different option for managing ties. » Read more
-
Displaying filter context in Power BI Tooltips
This article describes how to display the filter context applied to a calculation using a special DAX measure in Power BI Tooltips. » Read more
-
Table and column references using DAX variables
This article describes how to correctly use column references when manipulating tables assigned to DAX variables, avoiding syntax errors and making the code easier to read and maintain. » Read more
-
Using CONCATENATEX in measures
This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure. » Read more
-
Reading active Power BI security roles in DAX
This article describes how to read the active security roles in a Tabular model for Power BI or Analysis Services. This way, you can use measures and calculation groups to customize a report based dynamically on security roles active for the current user. » Read more
-
Show transaction details on the matrix visual in Power BI
This article shows how to create a DAX measure that displays information from multiple columns in a business entity or transaction, into a single column of a matrix. » Read more
-
Debugging DAX variables using TOJSON and TOCSV
This article describes how to use the TOJSON and TOCSV functions to inspect the content of intermediate table variables when debugging a DAX measure. » Read more
Related functions
Other related functions are:
Last update: Oct 29, 2026 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Francis Romio, Airat Gabdrakhmanov
Microsoft documentation: https://learn.microsoft.com/en-us/dax/concatenatex-function-dax