Question

How to concatenate in dax for more than 2 columns?

Answer 1

The text strings to be joined into a single text string. Strings can include text or numbers.

You can also use column references.

example :

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