How does the CONCATENATE function (DAX) work?

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

CONCATENATE Formula Syntax

     <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


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])


Related DAX Functions


Related Course Modules