Extract the first two words separated by space

[EJA12]

How to extract the first two words separated by space in another column, example I have the name MARIA ANGEL GOMEZ, I want that in another column only give me the name MARIA ANGEL and that it works with all the values of the column

[Kishore_KVN · Accepted solution]

Hello @EJA12 , We can do this easily using split columns in Power Query editor. But if you want to do this only in Power BI Desktop, you can use below DAX expressions:

My sample data is like this:

New column calculation will be like this:

Split = 
Var Replace_value = SUBSTITUTE(Data[Name]," ","+",2)
Var Find_Value = FIND("+",Replace_value,1,0)
Var Split_Value = IF(Find_Value>0,LEFT(Replace_value,Find_Value-1),Data[Name])
Return
Split_Value

Output looks like this:

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!