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
CONCATENATEX ( <table>, <expression>, [<delimiter>], [<OrderBy_Expression1>],[<Order>] … )
|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 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.
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: