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.

Share this:
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.

Ready to wrangle your data?