Bonjour à tous !
Une proposition ?
let
Source = Excel.CurrentWorkbook(){[Name="tSource"]}[Content],
ListDates = let
TD = Table.TransformColumnTypes(Source,{{"Start date", type date}, {"End date", type date}}),
LD = Table.AddColumn(TD, "Date", each List.Dates([Start date], Duration.Days([End date]-[Start date])+1, Duration.From(1)))
in Table.ExpandListColumn(LD, "Date"),
GroupBy = Table.Group(ListDates, {"Date"}, {{"Point considéré", each Text.Combine(List.Sort([Point considéré])," - "), type text}}),
TypeDate = Table.TransformColumnTypes(GroupBy,{{"Date", type date}}),
Filtre = Table.SelectRows(TypeDate, each Text.Contains([Point considéré]," - ")),
Final = Table.Group(Filtre, {"Point considéré"}, {{"Date", each Date.ToText(List.Min([Date])) & " - " & Date.ToText(List.Max([Date])), type nullable text}},0)
in
Final