Query to split space in a text string

[s15]

I have a column named FullName in which I apply [FirstName] & "" & [LastName] to make full name. Now I need to split a space between first name and last name in FullName column. As you can see below each full name has no space.

Is there a query formula I can use to make a space, e.g Terry Duffy, Rob Walters?

[TomMartens · Accepted solution]

Hey,

using Dax, just use this formula to create a calculated column

Fullname DAX = 'Table1'[Firstname] & " " & 'Table1'[Lastname]

Using the query editor

• switch to the "Add Column" ribbon
• mark both columns
• choose Merge Columns from "From Text" menu