CONCATENATE

Two texts joined into one (the & operator).

Group: Text. Compatible with DAX.

Syntax

CONCATENATE ( <text1>, <text2> )

Parameter	Type	Description
`text1`	Text	The text that comes first; a number or a date becomes text.
`text2`	Text	The text put after it.

Text. The two texts as one.

It takes exactly two arguments; a third is an error. To join more, nest the calls or use the & operator, which does the same and joins any number: "Bergen" & " " & "plant".
A blank counts as empty text. Only when both are blank is the result BLANK.
A number is written in the model's culture: 1.5 in an English model, 1,5 in a Norwegian one. Use FORMAT to choose how it looks.
To join the values of many rows, use CONCATENATEX.

EVALUATE
ROW ( "Joined", CONCATENATE ( "Pils", " 0.5 l" ) )

Joined
Pils 0.5 l

Nested, or with the & operator: the same text.

EVALUATE
ROW (
    "Nested", CONCATENATE ( "Bergen", CONCATENATE ( " ", "plant" ) ),
    "With &", "Bergen" & " " & "plant"
)

Nested	With &
Bergen plant	Bergen plant

EVALUATE
ROW (
    "Both blank", CONCATENATE ( BLANK (), BLANK () ),
    "One blank", CONCATENATE ( "x", BLANK () )
)

Both blank	One blank
(blank)	x

Last updated 3 November 2026 · OpenBI Studio 0.3.74