Bonjour,
@JFL
Cdlt.
let
Source = Excel.CurrentWorkbook(){[Name="t_Data"]}[Content],
Types = Table.TransformColumnTypes(Source,{{"Date", type date}, {"KM", Int64.Type}}),
AddPeriod = Table.AddColumn(Types, "Période", each Date.ToText([Date],"yyyy-MM")),
RemovedColumns = Table.RemoveColumns(AddPeriod,{"Date"}),
GroupedRows = Table.Group(RemovedColumns, {"Matricule", "Période"}, {{"KM", each List.Max([KM])-List.Min([KM]), type nullable number}}),
SortedRows = Table.Sort(GroupedRows,{{"Période", Order.Ascending}, {"Matricule", Order.Ascending}}),
PivotedColumn = Table.Pivot(SortedRows, List.Distinct(SortedRows[Période]), "Période", "KM")
in
PivotedColumn