Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to show only the rows associated with the last two dates per subject:
When I try the Top N filter with2, it gives me only the most recent two dates for all subjects.
Help, please.
@mmarchioni , Try new window function
TOPN using window = Sumx(KEEPFILTERS(Window(1,ABS,2,ABS, ALLSELECTED('Table'[Subject],'Table'[Date]),ORDERBY('Table'[Date],Desc),,PARTITIONBY('Table'[Subject]))), calculate(Countrows(Table)))
Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ
Unfortunately I have an older version of PowerBI (pre WINDOW fundtion) and can't upgrade yet. Is there another formula I can try?
User | Count |
---|---|
79 | |
77 | |
70 | |
68 | |
54 |
User | Count |
---|---|
107 | |
99 | |
88 | |
79 | |
67 |