Need to show rows associated with last 2 dates per subject

[mmarchioni]

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.

[amitchandak]

@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

[HLAdata]

From the questions you have posted it appears we are pulling the same kind of data. It would be interesting to chat and see what you have verse what I have and see if possibly we can help each other. There isn't many of us HLA data peoples out there:-)

[mmarchioni]

Unfortunately I have an older version of PowerBI (pre WINDOW fundtion) and can't upgrade yet. Is there another formula I can try?