DAX Function Guide

The two text strings joined by this function can be text, numbers, or Boolean values represented as text, or a combination of any of these items. You can also make use of a column reference if the said column has the appropriate values.

The CONCATENATE function in DAX language comprises of only two arguments, while in Excel, this function has up to 255 arguments. To be able to concatenate multiple columns, you will need to come up with a series of calculations. You can also use the concatenation operator to combine all of them and come up with a simpler expression.

If your aim is to use text strings directly, you will need to wrap each string in double quotation marks. This DAX function may come up with different results if the data model has been queried in DirectQuery mode.