DAX Text - CONCATENATE function


Advertisements

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

  • Text, or
  • Numbers, or
  • Column references.
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

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements