CONCATENATEX Function (DAX)

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

CONCATENATEX(
     <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

Understanding DAX Formula
Developing Complex Dax functions

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

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

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.