Power Query | Remove last word

[ovetteabejuela]

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 Name> <Middle Name>

How do you remove the <Middle Name>.

[janepettigrew]

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.

[janepettigrew]

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.

[Vvelarde · Accepted solution]

@ovetteabejuela

Hi, try with AddColumn-Extract :

Delimiter =  (Space)

Regards

Victor

[ovetteabejuela]

Thanks @Vvelarde, +1 to my learning and I won't forget that, it's already etched in my mind coz I need to.