Forum Discussion

lastnn30's avatar
lastnn30
Icon for Post Patron rankPost Patron
3 years ago
Solved

concatenate text with a space

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 di...
Need Help
  • jgeddes's avatar
    jgeddes
    3 years ago

    You can nest concatenate statements

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

lastnn30's avatar
lastnn30
Icon for Post Patron rankPost Patron
3 years ago

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's avatar
jgeddes
Icon for Super User rankSuper User
3 years ago

You can nest concatenate statements

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