Joins two text strings into one text string.
The first text string to be joined into a single text string. Strings can include text or numbers.
The second text string to be joined into a single text string. Strings can include text or numbers.
The concatenated string.
If you need to concatenate multiple columns, you can create a series of calculations or, better, use the concatenation operator (&) to join all of them in a simpler expression.
Learn more about CONCATENATE in the following articles:
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/concatenate-function-dax