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

 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 

any news on this regards?

 

Jimmy