Text Concatenation DAX operator (&) in Power BI
In this exercise, we will learn about the Text Concatenation operator ampersand (&) in DAX. It is used to combine (or concatenate) two or more text strings, numbers, or expressions into a single text string.
Syntax Expression1 & Expression2 [& Expression3]
Here Expression1, Expression2…are the expressions to concatenate.
Example: Let’s create a measure with name “Concatenate Operator Measure”.
DAX
Concatenate Operator Measure = "Hello" & " Ashish!"
The output of the above code is shown below:
Let’s modify the measure.
DAX
Concatenate Operator Measure = "Hello" & 123
The output of the above code is shown below:
Example: Let’s create a Calculated column in Power BI. Click on New Column.
DAX
Concatenate Column = Sheet12[Student Name] & " " & Sheet12[Marks]
The output of the above code is shown below:
