Forum Discussion

Mahipal's avatar
Mahipal
Icon for Helper I rankHelper I
2 years ago

How to split First Name and Last Name fromFull Name with" ," as delimiter using DAX in Direct Query

We have a requirement to split First and Last name from Fullname in direct query mode using DAX.  
Mahipal's avatar
Mahipal
Icon for Helper I rankHelper I
2 years ago

Hello Dangar332 your Query is working but results are not perfect. I am seeing same Name for all records.

 

  • Dangar332's avatar
    Dangar332
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    hi, Mahipal 

     

    you have any Unique identity on which we can add first name and last name in all rows.
    and why cash,johnny only is there any specific condition?

     

    • Mahipal's avatar
      Mahipal
      Icon for Helper I rankHelper I
      2 years ago

      I am using same query which you sent here. But the result is only one name. Here is query 

      Firstname = 
       LEFT(
          MIN('Users'[User Name]),
          SEARCH(",",MIN('Users'[User Name]))-1
      )
       
      Last name =
      RIGHT(
          MIN('Users'[User Name]),
          LEN(MIN('Users'[User Name]))-SEARCH(",",MIN('Users'[User Name]))
      )
       
      I need all names in results properly.