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
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

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

    • Jimmy801's avatar
      Jimmy801
      Community Champion
      6 years ago

      Hello Anonymous 

      any news on this regards?

       

      Jimmy