Forum Discussion
PowerBI123456
Post Partisan
Post PartisanLatest User
I am using the measure below to determine who put a request to a correspodning response. The problem is that it shows all the users who put in a request before the response date. I just want the late...
- Last Request User =var resp=CALCULATE(max(Activities[Index]),ALLEXCEPT(Activities,Activities[Account]),Activities[Activity ID]="Response")var req=CALCULATE(max(Activities[Index]),ALLEXCEPT(Activities,Activities[Account]),Activities[Activity ID]="Request",Activities[Index]<resp)return if(resp=BLANK(),resp,CALCULATE(max(Activities[User ID]),ALLEXCEPT(Activities,Activities[Account]),Activities[Index]=req))
PowerBI123456Post Partisan
Post Partisanlbendlin Thanks a lot!! Sorry to add one other criteria. I didnt realize it until I tested it and I am dealing with 10+ million rows, but another request can happen after a response. The measure is calculating the max request even if its after the response. For example with account 3, there is a request (Angela's) after the response but I don't care for that request since there is no response after. I only care about Jenny's request for account 3 . Hope that makes sense. Thank you so much for all your help!! I keep trying to add a table but its not letting me.