Power BI costum column Column, List.Sum “column of the table was not found”, why?

Question

I want running total in Power Bi,in Power Query,and I want sum of columns which I created by summing of three columns and I have used the following index

List.Sum(List.Range(#"Added Index"[Sum],0,[Index]))

and getting the following error "Expression.Error: The column 'Sum' of the table wasn't found."

How can I resolve it? 

Answer 1

Hi,try to create this in index column

#"Added Index" = Table.AddIndexColumn(#"Changed Type3", "Index", 1, 1),
    #"Changed Type4" = Table.TransformColumnTypes(#"Added Index",{{"ItalyZ", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type4", "Sum ItalyZ ItalyY ItalyB", each [Z Italy]+[Y Italy]+[B Italy]),
    #"Changed Type5" = Table.TransformColumnTypes(#"Added Custom",{{"Sum ItalyZ ItalyY ItalyB", Int64.Type}}),
    #"Added Custom1" = Table.AddColumn(#"Changed Type5", "Custom", each List.Sum(List.Range(#"Added Index"[Sum ItalyZ ItalyY ItalyB],0,[Index]))),
    #"Changed Type6" = Table.TransformColumnTypes(#"Added Custom1",{{"Custom", type number}}),
    Custom = #"Changed Type6"{0}[Custom]

Want to learn more about Power BI? Check out today: Power BI course