let
Source = Excel.CurrentWorkbook(){[Name="TAB_COMPTES"]}[Content],
#"Lignes filtrées" = Table.SelectRows(Source, each ([COMPTE] = "AAA") and ([BUDGET REEL] = "REEL")),
Jointure = Table.NestedJoin(#"Lignes filtrées", {"ANNEE", "COMPTE"}, #"Lignes filtrées", {"ANNEE", "COMPTE"}, "Source", JoinKind.LeftOuter),
Expand = Table.ExpandTableColumn(#"Lignes filtrées1", "Source", {"MOIS", "COMPTE", "DEBITCREDIT"}, {"MOIS.1", "COMPTE.1", "DEBITCREDIT.1"}),
#"Type modifié" = Table.TransformColumnTypes(Expand,{{"DATE", type date}}),
Filtre = Table.SelectRows(#"Type modifié", each [MOIS.1] <= [MOIS]),
GroupBy = Table.Group(Filtre, {"COMPTE", "ANNEE", "MOIS"}, {{"DEBITCREDIT", each List.Sum([DEBITCREDIT.1]), type number}}),
Tri = Table.Sort(GroupBy,{{"ANNEE", Order.Ascending}, {"COMPTE", Order.Ascending}, {"MOIS", Order.Ascending}})
in
Tri