How does the CONCATENATEX function (DAX) work?
The CONCATENATEX function (DAX) concatenates the result of an expression evaluated for each row in a table.
CONCATENATEX Formula Syntax
<table> , <expression>, [delimited]
How do you use the CONCATENATEX function?
The CONCATENATEX function used to merged text strings in DAX. You can use it in measures (in contrary to CONCATENATE, also available in DAX, which can be only used for merging of columns together).
Related Blog Posts
Related Support Forum Posts
Considerations when using the CONCATENATEX function
This function takes as its first argument a table or an expression that returns a table. The second argument is a column that contains the values you want to concatenate, or an expression that returns a value.
Related Video Tutorials
Formula examples using the CONCATENATEX function
CONCATENATEX(Employees, [FirstName] & “ “ & [LastName], “,”)
= CONCATENATE(Table1;Table1[Customer comment];”; “)
= CONCATENATEX (Products, [Product],”,”, [Product Key], DESC)
Related Course Modules
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.