CONCATENATE DAX Function in Power BI

The CONCATENATE DAX function joins only two text strings into one text string and returns the concatenated string.

DAX Syntax CONCATENATE(text1, text2)

The function has the following parameters:
• text1: The first text string to be joined into a single text string. The string can include text or numbers. We can also use column references.
• text2: The second text string to be joined into a single text string. The string can include text or numbers. We can also use column references.

Example: Let’s create a measure by concatenating two string literals.

DAX

Concatenate Measure = CONCATENATE("Hello", " Ashish!")

The output of the above dax function is shown below:

CONCATENATE dax function