Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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>.
Solved! Go to Solution.
Hi, try with AddColumn-Extract :
Delimiter = (Space)
Regards
Victor
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.
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.
Thanks @Vvelarde, +1 to my learning and I won't forget that, it's already etched in my mind coz I need to.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
68 | |
57 | |
52 | |
36 | |
34 |
User | Count |
---|---|
84 | |
71 | |
56 | |
45 | |
43 |