Running Totals - The Right Way!....how to duplicate code for multiple columns?|Power Query|Excel Forum|My Online Training Hub

Hi, I have successfully copied your code to create a Running Total for my report - thanks heaps 🙂

this is what I have....

BufferedValues = List.Buffer(#"Changed Type"[Total_Target]),

    RT = Table.FromList(fxRunning_Total(BufferedValues), Splitter.SplitByNothing(), {"RT"}),

    Columns = List.Combine({Table.ToColumns(#"Changed Type"), Table.ToColumns(RT)}),

    #"Converted to Table" = Table.FromColumns(Columns, List.Combine({Table.ColumnNames(#"Changed Type"), {"Running_Total"}})),

    #"Changed Type1" = Table.TransformColumnTypes(#"Converted to Table",{{"Running_Total", type number}}),

    #"Renamed Columns" = Table.RenameColumns(#"Changed Type1",{{"Running_Total", "Total_Target_Running_Total"}})

but now I need to duplicate this for a few more columns...at what part of the code to I need to copy & paste to add in new running total columns for RED & BLUE Targets?

many thanks,

Francine