I was trying to do something like this:
if(Aggr(max(ModifiedDate), UserId, ReportStatus) ...but it's not working.
In pure English, what I am trying to do is return a User's report status if their Modified Date is the latest. Is something in my statement incorrect or am I approaching the problem incorrectly?
Try with Firstsortedvalue() function
firstsortedvalue(ReportStatus, Orderdate) gets the UserId with the minumum orderdate
firstsortedvalue(ReportStatus, -Orderdate) gets the UserId with the maximum orderdate
Refer this link
Hope it helps