let
Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
Etat0 = Table.TransformColumnTypes(Source,{{"Entrepôt", type text}, {"Livreur", type text}, {"ID de la tâche", type any}, {"Date", type date}, {"Avancement", type text}, {"Statut", type text}, {"Tournée", type text}, {"Séquence", Int64.Type}, {"Départ", type time}, {"Arrivée", type time}, {"Représentant du client", type text}, {"Numéro", Int64.Type}, {"Rue", type text}, {"Code postal", Int64.Type}, {"Ville", type text}, {"Pays", type text}, {"Heure de clôture", type time}}),
#"Lignes filtrées" = Table.SelectRows(Etat0, each ([Statut] = "Non livré") and ([Date] =Record.Field(Table.Max(Etat0, "Date"),"Date"))),
#"Lignes groupées" = Table.Group(#"Lignes filtrées", {"ID de la tâche", "Date"}, {{"Nombre", each Table.RowCount(_), Int64.Type}})
in
#"Lignes groupées"