Forum Discussion

Einomi's avatar
Einomi
Helper V
3 years ago
Solved

Sum certain columns

Hi,   Very common topic, but I cannot find an easy and proper solution. I have data coming and I applied some transformations to unpivot the data. As a result, I have 7 columns (the 7 first) that g...
General Comment
Need Help
Show and Tell
Tutorial Requests
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    3 years ago

    This would work

    let
    Source = Consolidation,
    #"Colonnes supprimées" = Table.RemoveColumns(Source,{"What is your e-mail address ?", "Loyalty Card", "Card Number"}),
    #"Espaces supprimés" = Table.TransformColumns(#"Colonnes supprimées",{{"City", Text.Trim, type text}}),
    FirstColRef = 7,
    RowTotal = Table.AddColumn(#"Colonnes supprimées", "Sum", each List.Sum(List.Skip(Record.ToList(_),FirstColRef)))
    in    
        RowTotal