Power BI DAX CONCATENATEX function concatenates the result of an expression evaluated for each row in a table using the specified delimiter. It come under Text filter Dax function category.
Refer similar Dax function: CONCATENATE DAX
Syntax:
CONCATENATEX (
<table>, <expression>, [<delimiter>], [<OrderBy_Expression1>],[<Order>] …
)
Description:
| S no. | Parameter | Description |
| 1 | table | The table containing the rows for which the expression will be evaluated. |
| 2 | expression | The expression to be evaluated for each row of the table. |
| 3 | delimiter | Optional, A separator to use during concatenation. |
| 4 | orderBy_expresion1 | Optional, Column by which the values are to be concatenated. |
| 5 | order | ASC: To sort in an ascending order. |
| DESC: To sort in a descending order. | ||
| If omitted, default is ASC. |
Let’s start with an example:
Step-1: Sample Dataset as below:
Step-2: Create three new columns using the following three DAX expressions.
CONCAT_Default =
CONCATENATEX(Users,Users[Manager],",")
CONCAT_with_OrderBy_ASC =
CONCATENATEX(Users,Users[Manager],",", Users[Region],ASC)
CONCAT_with_OrderBy_DESC =
CONCATENATEX(Users,Users[Manager],",", Users[Region],DESC)
Step-3: Drag the following three columns onto the table visual and see the resulting output below.
CONCATENATEX Example
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.
Recommended DAX Post: