concatenate text with a space

[lastnn30]

Hi

I wanted to join firstname and lastname and put a space between them. I tried to insert a column with this dax formula

Column = CONCATENATE(names[First Name]&" "&names[Last Name])

but did not work. Any idea please? Thank you very much

[jgeddes]

Column = names[First Name]&" "&names[Last Name] should work without the concatenate statement.

[lastnn30]

It does work without concat function. Thank you. But if I want to use concat function, how can I insert the space. Thank you again.

[jgeddes · Accepted solution]

You can nest concatenate statements

CONCATENATE(names[First Name], CONCATENATE(" ", names[Last Name]))