Skip to main content

 

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, etext2], ...)

Be the first to reply!