CONCATENATE Function (DAX)

How does the CONCATENATE function (DAX) work?

The CONCATENATE function (DAX) combines two text strings into one.

CONCATENATE Formula Syntax

CONCATENATE(
     <text1>, <text2>
)

How do you use the CONCATENATE function?

The two text strings joined by this function can be text, numbers, or Boolean values represented as text, or a combination of any of these items. You can also make use of a column reference if the said column has the appropriate values.

Related Blog Posts

Related Support Forum Posts

Count all products
SUMX vs row by row multiplication
DATEADD within SUMX returning 0 or blank

Considerations when using the CONCATENATE function

The CONCATENATE function in DAX language comprises of only two arguments, while in Excel, this function has up to 255 arguments. To be able to concatenate multiple columns, you will need to come up with a series of calculations. You can also use the concatenation operator to combine all of them and come up with a simpler expression.

If your aim is to use text strings directly, you will need to wrap each string in double quotation marks. This DAX function may come up with different results if the data model has been queried in DirectQuery mode.

Related Video Tutorials

Formula examples using the CONCATENATE function

=CONCATENATE(Customer[LastName], CONCATENATE(“, “, Customer[FirstName]))

=CONCATENATE(‘Products'[Product abbreviation],’Products'[Product number])

=CONCATENATE(B2, ” “, C2)

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership