Summing Columns in a Table

Hi Anonymous ,

Scenario:

If you want to keep any columns other than "EBIT",

1. Reorder Column to move all "EBIT" column to the end:

Code: Table.ReorderColumns(#"Changed Type",List.Combine({List.Select(Table.ColumnNames(PreviousStep), each not Text.Contains(_,"EBIT",Comparer.OrdinalIgnoreCase)), List.Select(Table.ColumnNames(PreviousStep), each Text.Contains(_,"EBIT",Comparer.OrdinalIgnoreCase))}))

then,

2. Add a custom column and add sum lastN columns:

Code: List.Sum(List.LastN(Record.ToList(_),List.Count(List.Select(Table.ColumnNames(PreviousStep), each Text.Contains(_,"EBIT",Comparer.OrdinalIgnoreCase)))))

WOW that is Awesome. Not Intuative - I would never have figured this out

Two Fantastic Snippits of Code  that I am Going to Use Over and Over Again