Forum Discussion

s15's avatar
s15
Helper III
9 years ago
Solved

Query to split space in a text string

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 ...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    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

TomMartens's avatar
TomMartens
Super User
9 years ago

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