Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ovetteabejuela
Impactful Individual
Impactful Individual

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

 

How do you remove the <Middle Name>.

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@ovetteabejuela

 

Hi, try with AddColumn-Extract :

 

Delimiter =  (Space)

 

Regards

 

Victor

 

img1.png




Lima - Peru

View solution in original post

4 REPLIES 4
janepettigrew
New Member

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
New Member

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
Community Champion
Community Champion

@ovetteabejuela

 

Hi, try with AddColumn-Extract :

 

Delimiter =  (Space)

 

Regards

 

Victor

 

img1.png




Lima - Peru

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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors