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.
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/concatenate-function-dax