1 2 3 4 5 6 7 8 9
| let
Source = Excel.CurrentWorkbook(){[Name="t_Mouvements"]}[Content],
AdapterTypes = Table.TransformColumnTypes(Source,{{"Article", type text}, {"Date", type date}, {"Type", type text}, {"Qté", Int64.Type}}),
FiltrerSorties = Table.SelectRows(AdapterTypes, each ([Type] = "Sortie")),
RegrouperArticles = Table.Group(FiltrerSorties, {"Article"}, {{"Qtés", each List.Sum([Qté]), type nullable number}}),
TrierTQuantités = Table.Sort(RegrouperArticles,{{"Qtés", Order.Descending}}),
ConserverTop3 = Table.FirstN(TrierTQuantités,3)
in
ConserverTop3 |
Partager