1 2 3 4 5 6 7
| let
Source = Excel.CurrentWorkbook(){[Name="Tableau1"]}[Content],
#"Type modifié" = Table.TransformColumnTypes(Source,{{"Ref", type text}, {"Mont 1", Int64.Type}, {"Mont 2", Int64.Type}, {"Mont 3", Int64.Type}, {"Mont 4", Int64.Type}, {"Mont 5", Int64.Type}}),
#"Lignes groupées" = Table.Group(#"Type modifié", {"Ref"}, {{"Mont 1", each List.Sum([Mont 1]), type nullable number}, {"Mont 2", each List.Sum([Mont 2]), type nullable number}, {"Mont 3", each List.Sum([Mont 3]), type nullable number}, {"Mont 4", each List.Sum([Mont 4]), type nullable number}, {"Mont 5", each List.Sum([Mont 5]), type nullable number}}),
#"Lignes triées" = Table.Sort(#"Lignes groupées",{{"Ref", Order.Ascending}})
in
#"Lignes triées" |
Partager