Forum Discussion

PowerBI123456's avatar
PowerBI123456
Post Partisan
5 years ago
Solved

Latest 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...
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    5 years ago
    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))
PowerBI123456's avatar
PowerBI123456
Post Partisan
5 years ago

lbendlin  Sorry its not letting me attached a table. I keep getting an error message. But I added an account 4 which shows no response yet. I wouldnt want to know who the requester is for that account.