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 there
If I want to clean up a text field by removing text such as "CO" "LTD" "UK" I have an issue where if those values are within a word, they are also removed. I cannot include spaces either side of the word because quite often they are at the end of the field.
Is there any way around this?
Is there a character I can include which tells Power BI to look for these values independently but without the use of spaces? Jemma
Solved! Go to Solution.
@Anonymous
Please refer to this blog, you can just replace with blank.
Multiple replacements or translations in Power BI and Power Query – The BIccountant
Paul Zheng _ Community Support Team
@Anonymous
Please refer to this blog, you can just replace with blank.
Multiple replacements or translations in Power BI and Power Query – The BIccountant
Paul Zheng _ Community Support Team
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 |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |