Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to split column till delimiter using DAX

Hi All,   I have column let say Name it is having values like brian lara now i want to create a new column using DAX that have only first name like "brian" . How to do it using Dax?      
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks Jimmy.

    Can you please recheck the DAX column formula which you have sent to me. 

    It is not working for me.

    I have tried Following one and it worked fine :

    First name = LEFT(SUBSTITUTE(Players[Name]," ","-"),SEARCH("-",SUBSTITUTE(Players[Name]," ","-"))-1)
     
     
    Cheers,
    Deepak Baberwal
Jimmy801's avatar
Jimmy801
Community Champion
6 years ago

Hello

try to use this Syntax

left(<your text>;find(" ";<your text>)-1)

have fun

Jimmy

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Jimmy.

Can you please recheck the DAX column formula which you have sent to me. 

It is not working for me.

I have tried Following one and it worked fine :

First name = LEFT(SUBSTITUTE(Players[Name]," ","-"),SEARCH("-",SUBSTITUTE(Players[Name]," ","-"))-1)
 
 
Cheers,
Deepak Baberwal
  • Jimmy801's avatar
    Jimmy801
    Community Champion
    6 years ago

    Hey

    my solution works just fine

     

    Jimmy

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    6 years ago

    Hello Anonymous ,

     

    any news here?

     

    Jimmy

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

       Hi,

       

      Actually i want DAX Solution.

      I think your solution is working fine with excel but not in Power BI .

      • Jimmy801's avatar
        Jimmy801
        Community Champion
        6 years ago

        Hello Anonymous 

         

        my solution is DAX and DAX is present in Power BI as well as Excel.

        If I would pass data in Power BI from Power Query to Power Pivot I would always prefer to "transform" the data in Power Query, not in Power Pivot (DAX).

         

        I would appreciate if you mark my answer as solution as well 🙂

         

        If this post helps or solves your problem, please mark it as solution.
        Kudos are nice to - thanks
        Have fun

        Jimmy