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.
» 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: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/concatenate-function-dax