Bonjour à tous !
Une tentative ?
let
Source = Excel.CurrentWorkbook(){[Name="T_ORIGINE"]}[Content],
TypeDate = Table.TransformColumnTypes(Source,{{"DATE DE DEBUT", type date}, {"DATE DE FIN", type date}}),
Idx = Table.AddIndexColumn(TypeDate, "Index", 0, 1),
FiltreProduit = Table.SelectRows(Idx, each ([#"N° PDT"] <> null)),
LD = Table.AddColumn(FiltreProduit, "LD", each List.Dates([DATE DE DEBUT], Duration.Days([DATE DE FIN]-[DATE DE DEBUT])+1, Duration.From(1))),
ExpandLD = Table.ExpandListColumn(LD, "LD"),
LM = Table.AddColumn(ExpandLD, "MMAAAA", each Date.ToText([LD],"MM-yyyy")),
GroupBy = Table.Group(LM, {"N° PDT", "IDENTITE PDT", "PRESTATION", "PRIX UNITAIRE", "Index", "MMAAAA"}, {{"DATE DE DEBUT", each List.Min([LD]), type nullable date}, {"DATE DE FIN", each List.Max([LD]), type nullable date},{"NB jours", each List.Count([LD]), Int64.Type},{"MONTANT", each List.Count([LD])* [PRIX UNITAIRE]{0}, type number}}),
VTE = Table.RemoveColumns(GroupBy,{"MMAAAA"}),
FiltreNull = Table.SelectRows(Idx, each ([#"N° PDT"] = null)),
RequêteAjoutée = Table.Combine({FiltreNull, VTE}),
Tri = Table.Sort(RequêteAjoutée,{{"Index",0}, {"DATE DE DEBUT", 0}}),
IdxSupp = Table.RemoveColumns(Tri,{"Index"})
in
IdxSupp