Power Query List.MaxN

[SamanAteeq]

= Table.SelectRows(#"Sorted Rows", each [FYear] = List.MaxN(#"Sorted Rows"[FYear],5)) not filtering the Top N rows, though List.Max function is working perfectly

can someone help me?

[Fowmy · Accepted solution]

@SamanAteeq 

Try it this way:

Table.SelectRows(#"Sorted Rows", (x)=> List.ContainsAny( List.MaxN(#"Sorted Rows"[FYear],5), {x[FYear]} ))