Removing Excess Spaces Between Words AKA Inner Trim (Power BI)

Text.Trim() does an excellent job of getting rid of things like

 "   leading spaces"

and

"trailing spaces     "

but unlike its’ Excel cousin it doesn’t handle

"excess     inner       spaces"

at all.

Granted these problems aren’t as ubiquitous as the first two (which show up in hand generated Excel data and web data all the time), but if you need them gone you need them gone. In this video, we show you a cool way to leverage Text.Split() and Text.Combine() to isolate shed those pesky double spaces and knock them out of your precious data for good.

Happy Reporting!!

Brian Grant

Brian Grant

Brian Grant is a masterful Senior Analytics Consultant by day, and a Power BI legend by night. A passion for Power BI drove him to holistically master the tool from all three perspectives: M, DAX, and the visualization layer. Brian is a constant teacher who leads Power BI training sessions, while sharing his wealth of expertise through video and blogging resources.
SHARE THIS
Share on twitter
Share on facebook
Share on linkedin
Share on email
RELATED POSTS

Subscribe

Subscribe to CSG. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Ready to wrangle your data?