Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
110 | |
100 | |
39 | |
30 |