Transform Multiple Columns at Once in M

If you’ve got a large number of columns on a table to transform it can be quite a hassle. Here we’ll show a way to use List. Transform along with some code fishing techniques to whip up a solution to convert a huge number of columns all at once without too much fanfare and only a single step in your code.

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?