Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
8 years ago
Solved

Power Query | Remove last word

Hi Guys & M-Gurus,   How would you remove the last word in a text, actually in my case I'm trying to remove middle names which are placed at the end portion of the name:   <First Name>, <Last Nam...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    ovetteabejuela

     

    Hi, try with AddColumn-Extract :

     

    Delimiter =  (Space)

     

    Regards

     

    Victor

     

janepettigrew's avatar
janepettigrew
New Member
7 years ago

Thank you for this solution, however I am hoping to find out how to do this when there are multiple words, and several space delimiters in a field. I need to remove the last word only.

 

Using the Contoso sales data as an example, all the products have the colour at the end of the Product Name field. I am looking to remove the colour and leave the product name only in the column, but the product names consist of several words. There are numerous spaces in each name, but the colour is only ever the last word of the field.  I am new to DAX and Power BI, but not new to Excel and text functions. 

 

Thanks in advance.