How to split column till delimiter using DAX

[Anonymous]

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?

[Jimmy801]

Hello

try to use this Syntax

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

have fun

Jimmy

[Anonymous · Accepted solution]

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]

Hello @Anonymous ,

any news here?

Jimmy

[Anonymous]

 Hi,

Actually i want DAX Solution.

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

[Jimmy801]

Hello @Anonymous 

any news on this regards?

Jimmy

[Jimmy801]

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]

Hey

my solution works just fine

Jimmy