Custom Column Transformations in Power Query

Applying standard transformations to several columns at once is a snap in Power Query. Select all the columns, right click on them, go to transform and pick your pleasure. Boom, done, easy.

If you want to do custom transformations though the story is much different. Add a custom column for each column you want to transform with something like “(Fixed)” tacked on to the end of the column name, delete the original column, then rename your new column so it doesn’t have that “(Fixed)” sillyness in the title. That’s a lot of work and a lot of applied steps in your code for what is really one transformation.

In this video we’ll look at using custom function queries paired with an M code hack to get you that nice, clean, single step transformation you knew in you heart of hearts existed out there somewhere.

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 on twitter
Share on facebook
Share on linkedin
Share on email


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

Ready to wrangle your data?