DAX formula to concatenate three columns

Question

How can I concatenate three different columns say First_Name, Middle_Name, and Last_Name to a single column with space in between using the CONCATENATE function in DAX?

Answer 1

If the columns are already text, you can use the & operator, i. e. use

[FIRST_NAME] & " " & [LAST_NAME]