Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
= 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
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |