What is trimming and why is it required?

Parthiban Kannan

Updated on February 9, 2026

< 1 min read

Trimming means removing extra spaces from the beginning and end of text values.
In my project, customer names like ” John Doe ” were trimmed to “John Doe”.
It ensures consistent matching when joining tables or applying filters.
Prevents duplicate-looking values caused by invisible spaces.
Improves sorting, grouping, and aggregation accuracy in reports.
Trimming also avoids calculation errors in conditional logic.
We applied it to all text columns during Power Query transformation.
It makes dashboards clean and user-friendly.
So trimming is essential for reliable and accurate text data processing.