How to concatenate multiple column in Power BI

Join two text strings into one text string.

The CONCATENATE function joins two text strings into one text string. The joined items can be text, numbers or Boolean values represented as text, or a combination of those items. You can also use a column reference if the column contains appropriate values.

CONCATENATEX Function in Power BI?

The CONCATENATE function in DAX accepts only two arguments, whereas the Excel CONCATENATE function accepts up to 255 arguments. 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.

Related Article:
How to Fix Power BI SASL Authentication Error with Impala
CONCATENATEX Function in Power BI
How to concatenate multiple column in Power BI

If you want to use text strings directly, rather than using a column reference, you must enclose each string in double quotation marks.

DAX Syntax:

CONCATENATE(<text1>, <text2>)

The below formula creates a new calculated column in the Customer table with the full customer name as a combination of first name, middle initial, and last name. If there is no middle name, the last name comes directly after the first name. If there is a middle name, only the first letter of the middle name is used and the initial letter is followed by a period.

Concatenate multiple columns syntax:

=CONCATENATE( [FirstName]&" ", CONCATENATE( IF( LEN([MiddleName])>1, LEFT([MiddleName],1)&" ", ""), [LastName]))

Note: The CONCATENATE function in DAX (Power BI)accepts only two argument. if you have more than two columns(including custom text) you have to use nested CONCATENATE function as above example, We’ve used CONCATENATE function twice.

Related Article:
How to Fix Power BI SASL Authentication Error with Impala
CONCATENATEX Function in Power BI
How to concatenate multiple column in Power BI

Feel free to comment your problems related to CONCATENATE or any other in Power BI, I’ll try to respond ASAP.