CONCATENATE Function (DAX)

How does the CONCATENATE function (DAX) work?

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

CONCATENATE Formula Syntax

CONCATENATE(
     <text1>, <text2>
)

How do you use the CONCATENATE function?

The CONCATENATE function joins two text strings into one text string. The joined items can be text, numbers or Boolean values represented as text, or a combination of those items. You can also use a column reference if the column contains appropriate values.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the CONCATENATE function

The CONCATENATE function in DAX accepts only two arguments, whereas the Excel CONCATENATE function accepts up to 255 arguments. If you need to concatenate multiple columns, you can create a series of calculations or, better, use the concatenation operator (&) to join all of them in a simpler expression.

If you want to use text strings directly, rather than using a column reference, you must enclose each string in double quotation marks.

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

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.