Forum Discussion
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...
- 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))
Please provide sample data in usable format (not as a picture) , show the expected outcome, and give sufficient context.
How do I attach data? Here is what it looks like:
Here is what my measure getting me:
Here is what I want. I only want to see the last requester if there was a response: