Bonjour,
Quelques modifications !?
Cdlt.
let
Source = Excel.CurrentWorkbook(){[Name="Tableau1"]}[Content],
Types = Table.TransformColumnTypes(Source,{{"DATE", type date}, {"QTTE", Int64.Type}, {"PUNIT ACHAT", Int64.Type}}),
TriCroissant = Table.Sort(Types,{{"DATE", Order.Ascending}}),
#"Cout de revient total" = Table.AddColumn(TriCroissant, "CRT", each [QTTE]*[PUNIT ACHAT],Int64.Type),
Index_ajouté = Table.AddIndexColumn(#"Cout de revient total", "Index", 1, 1),
CumulQTTE = Table.AddColumn(Index_ajouté, "QTTE cumulée", each List.Sum(List.Range(Index_ajouté[QTTE],0,[Index])),Int64.Type),
CumulCRT = Table.AddColumn(CumulQTTE, "CRT cumulé", each List.Sum(List.Range(Index_ajouté[CRT],0,[Index])))
in
CumulCRT