Forum Discussion

SamanAteeq's avatar
SamanAteeq
Microsoft Employee
5 years ago
Solved

Power Query List.MaxN

= 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?

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    SamanAteeq 

    Try it this way:

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

1 Reply

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    SamanAteeq 

    Try it this way:

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