Power Query - Looping through Columns

Looping in M-query is not as straight forward a with other scripting languages like python. In this tutorial I show you how to iterate and transform columns in a table without repeating the transformation manually. #data #dataanalysis #excel #powerquery #mquery #powerbi #tutorial #etl File Link https://github.com/jbotes/powerbiTuto... Function used 1 - Table.TransformColumns 2 - List.Sum 3 - List.Select 4 - Table.ColumnNames 5 - Text.Contains 6 - List.Accumulate