let
Source = Table.Combine({Table1, Table2}),
#"Lignes groupées" = Table.Group(Source, {"Client", "PartNo", "Titre", "TYPE", "Start Date projected", "End Date projected", "Projet Name"}, {{"Real End Date", each List.Max([Real End Date]), type nullable date}})
in
#"Lignes groupées"