& function

Prev Next

Description

Concatenates all the given text arguments.

Syntax

text1 & text2 & ...
  • Each argument should have text type, using TEXT if needed

  • If Metrics are used, they should be at least on the Dimensions of the target Metric

Return type

Text

Examples

Case

Results

Return Type

"abc" & " - " & "123"

"abc - 123"

Text

Building a new list Property from existing ones: Country.Name & "(" & Country.Region & ")"

"France (Europe)"

Text

Excel equivalent: CONCAT(text1, [text2], ...)