Home » DAX » DAX – CONCATENATEX Function

DAX – CONCATENATEX Function

CONCATENATEX DAX Functions

Power BI DAX CONCATENATEX function concatenates the result of an expression evaluated for each row in a table using the specified delimiter. Its 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:

Sample Data

Step-2: Create new three columns with below three DAX’s.

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 below three columns to Table visuals and see the below output.

CONCATENATEX Example

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:

LEFT

LOWER

UPPER

ALLEXCEPT

UNION

DATATABLE

ALLSELECTED

ALL

ADDCOLUMNS

CONCATENATE

Leave a Reply