Home » DAX » DAX – CONCATENATE Function

DAX – CONCATENATE Function

CONCATENATE DAX Functions

Power BI CONCATENATE DAX function is used to join two text strings into one text string. Its comes under Text Filter DAX functions category.

Refer similar Dax function: CONCATENATEX DAX



Syntax :

CONCATENATE( <Text1>, <Text2> )

Description:

S no. Parameter Description
1 Text1 First text strings to be joined into a single text string. Text strings can be Number or Text
2 Text2 Second text strings to be joined into a single text string. Text strings can be Number or Text

Let’s start with an example:




Step 1: Sample Dataset as below:

Sample Dataset for DAX String Functions

Sample Dataset for DAX String Functions

Step 2: Create New column, right click on Dataset & click on New column.



Step 3: Write DAX for CONCATENATE two strings.

CONCATENATE_Result = 

CONCATENATE(Orders[Product Category], Orders[Product Sub-Category])

Above DAX join two string without any space, if you want to add space or any special symbol between two string then write below DAX.

CONCATENATE_With_Space =
CONCATENATE(
CONCATENATE( Orders[Product Category], " " ),
Orders[Product Sub-Category]
)

Step 4: Now drag new columns to Table Visual & see the output

CONCATENATE Example

CONCATENATE DAX function Example

Refer similar Dax function: CONCATENATEX DAX

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.



Recommended DAX Post:

RIGHT

LEFT

LOWER

UPPER

ALLEXCEPT

UNION

DATATABLE

ALLSELECTED

ALL

ADDCOLUMNS

Leave a Reply