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))
lbendlin
Super User
Super UserYou did not specify that clear enough (at least not for me), and your sample data has responses for all cases. Please provide better sample data, this time in a table, please.