Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
= 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?
Solved! Go to Solution.
@SamanAteeq
Try it this way:
Table.SelectRows(#"Sorted Rows", (x)=> List.ContainsAny( List.MaxN(#"Sorted Rows"[FYear],5), {x[FYear]} ))
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@SamanAteeq
Try it this way:
Table.SelectRows(#"Sorted Rows", (x)=> List.ContainsAny( List.MaxN(#"Sorted Rows"[FYear],5), {x[FYear]} ))
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |