1 2 3 4 5 6 7
| let
Source = Excel.CurrentWorkbook(){[Name="Tableau1"]}[Content],
TypesAdaptés = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Famille", Int64.Type}, {"Lot", Int64.Type}, {"Qté vendue", Int64.Type}, {"Qté fabriquée", Int64.Type}}),
LignesGroupées = Table.Group(TypesAdaptés, {"Date", "Famille", "Lot"}, {{"Vendu", each List.Sum([Qté vendue]), type nullable number}, {"Fabriqué", each List.Sum([Qté fabriquée]), type nullable number}}),
StockCalculé = Table.AddColumn(LignesGroupées, "Stock", each List.Sum({[Fabriqué],-[Vendu]}))
in
StockCalculé |
Partager