Forum Discussion

Icon for Post Patron rank

Post Patron

4 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 did not work. Any idea please? Thank you very much

jgeddes
4 years ago
You can nest concatenate statements
CONCATENATE(names[First Name], CONCATENATE(" ", names[Last Name]))

3 Replies

jgeddes
Super User
4 years ago
Column = names[First Name]&" "&names[Last Name] should work without the concatenate statement.
- lastnn30
  Post Patron
  4 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
    Super User
    4 years ago
    You can nest concatenate statements
    CONCATENATE(names[First Name], CONCATENATE(" ", names[Last Name]))

Related content