Forum Discussion
Extract the first two words separated by space
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
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_ValueOutput 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!!
1 Reply
- Kishore_KVN
Solution Sage
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_ValueOutput 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!!