Bonjour à tous de nouveau !
Version amendée :
let
Source = Excel.CurrentWorkbook(){[Name="T_CA"]}[Content],
GroupBy = Table.Group(
Source,
{"SOCIETE"},
{
{"Top N", each Table.FirstN(Table.Sort(_, {"CA",Order.Descending}),3)},
{"Flop N", each Table.FirstN(Table.Sort(_, {"CA",Order.Ascending }),3)}
}),
Unpivot = Table.UnpivotOtherColumns(GroupBy, {"SOCIETE"}, "Classement", "Valeur"),
Expand = Table.ExpandTableColumn(Unpivot, "Valeur", {"ETAB", "CA"}, {"ETAB", "CA"}),
Jointure = Table.NestedJoin(Source, {"SOCIETE", "ETAB", "CA"}, Expand, {"SOCIETE", "ETAB", "CA"}, "Résultat", JoinKind.LeftOuter),
Résultat = Table.TransformColumns(Jointure,{"Résultat", each if Table.IsEmpty(_) then "Faux" else "Vrai", Text.Type})
in
Résultat