Bonjour à tous !
Une proposition de requête pour T_AJOUT :
let
Source = Excel.CurrentWorkbook(){[Name="T_AJOUT"]}[Content],
Types = Table.TransformColumnTypes(Source,{{"DATE DE DEBUT", type date}, {"DATE DE FIN", type date}}),
Jointure = Table.NestedJoin(Types, {"PRODUITS", "TYPE"}, T_ORIGINE, {"PRODUITS", "TYPE"}, "T_ORIGINE", JoinKind.LeftOuter),
Expand = Table.ExpandTableColumn(Jointure, "T_ORIGINE", {"DATE DE DEBUT", "DATE DE FIN"}, {"DATE DE DEBUT.1", "DATE DE FIN.1"}),
Test = Table.AddColumn(Expand, "Test", each try if [DATE DE DEBUT]>=[DATE DE DEBUT.1] and [DATE DE FIN]<=[DATE DE FIN.1] then "OUI" else "NON" otherwise "NON"),
GroupBy = Table.Group(Test, {"PRODUITS", "TYPE", "DATE DE DEBUT", "DATE DE FIN", "NB JOURS", "MONTANT"}, {{"INTERVALLE", each if List.Contains([Test],"OUI") then "OUI" else "NON", type text}})
in
GroupBy