CONCATENATE DAX Function (Text)
Joins two text strings into one text string.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Text1 |
The first text string to be joined into a single text string. Strings can include text or numbers. |
|
| Text2 |
The second text string to be joined into a single text string. Strings can include text or numbers. |
Return values
The concatenated string.
Remarks
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.
CONCATENATE accepts only two arguments. A third argument returns an error. To join three or more values, use the & operator, for example Customer[Customer Name] & ” – ” & Customer[Customer Code]. You can also put a CONCATENATE function inside another CONCATENATE function.
CONCATENATE converts numbers, dates, and Boolean values to text with the default format. For example, CONCATENATE ( 1.5, TRUE () ) returns “1.5TRUE”. To control the format, use FORMAT, for example CONCATENATE ( “Total: “, FORMAT ( 1234.5, “#,0.00” ) ) returns “Total: 1,234.50”.
A BLANK argument is an empty string. If both arguments are BLANK, the result is BLANK. CONCATENATE ( Text1, Text2 ) gives the same result as Text1 & Text2.
» 1 related function
Examples
-- CONCATENATE concatenates two strings.
-- It is an alternative to the more commonly used & operator
-- that also allows to concatenate multiple expressions.
EVALUATE
ADDCOLUMNS (
SUMMARIZE (
TOPN ( 5, Customer ),
Customer[Customer Code],
Customer[Customer Name]
),
"Name and Code 1",
CONCATENATE (
Customer[Customer Name],
Customer[Customer Code]
),
"Name and Code 2",
Customer[Customer Name] & Customer[Customer Code]
)
| Customer Code | Customer Name | Name and Code 1 | Name and Code 2 |
|---|---|---|---|
| 11024 | Xie, Russell | Xie, Russell11024 | Xie, Russell11024 |
| 11036 | Russell, Jennifer | Russell, Jennifer11036 | Russell, Jennifer11036 |
| 11041 | Carter, Amanda | Carter, Amanda11041 | Carter, Amanda11041 |
| 11043 | Simmons, Nathan | Simmons, Nathan11043 | Simmons, Nathan11043 |
| 11928 | Morris, Isabella | Morris, Isabella11928 | Morris, Isabella11928 |
Related articles
Learn more about CONCATENATE in the following articles:
-
Using CONCATENATEX in measures
This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure. » Read more
Related functions
Other related functions are:
Last update: Oct 29, 2026 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/concatenate-function-dax