- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
DAX Text - CONCATENATE function
Description
Joins two text strings into one text string.
Syntax
CONCATENATE (<text1>, <text2>)
Parameters
| Parameter | Description |
|---|---|
| text1 |
The text strings to be joined into a single text string. Text strings can be
|
| text2 |
Return Value
The concatenated string.
Remarks
DAX CONCATENATE function accepts only two arguments.
If you need to concatenate multiple columns, you can either nest the CONCATENATE functions or use the text concatenation operator (&) to join all of them.
If you want to use text strings directly, rather than using column references, you must enclose each text string in double quotation marks.
Example
= CONCATENATE ("John ","Lever") returns John Lever.
= CONCATENATE (LEFT ([Product], 5), [No. of Units])
returns a calculated column with values left 5 characters of Product concatenated with No. of Units in the corresponding row.
dax_functions_text.htm
Advertisements