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.
Hello,
How could I remove the trailing spaces in my table field named Vendor?
I can filter for vendors with a space at the end but I dont know how I can remove the space at the end.
I am not sure what else woudl need to be know but feel free to reach out.
I know I can use trim in excel but I want to use power query to do this.
I am a novice user.
thank you
Solved! Go to Solution.
Hi,
here you find the command you need (trim)
provide a sample data if you need something else
If this post is useful to help you to solve your issue consider giving the post a thumbs up 👍 and accepting it as a solution !
that was perfect! thank you very much!
Hi,
here you find the command you need (trim)
provide a sample data if you need something else
If this post is useful to help you to solve your issue consider giving the post a thumbs up 👍 and accepting it as a solution !
Thank you for the screen shot, this did exactly what I needed.
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 |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |