Forum Discussion
Rolling 28 Day Measure
A version of this question has been asked numerous times, but I still cannot figure it out from all the other examples. I am trying to calculate a rolling 28 day count of responses.
A view of my data set is below, as is my current formula for the measure. What I thought this would do was sum up the count of responses across the last 28 days, but all it seems to return is the latest day values. In addition, I want the measure to be responsive to additional filters from the data set below - IsUserInternal and Service. It seems to be doing that, but, again, only showing the counts for the specific day
Thanks in advance.
28DResponses = CALCULATE(sum('Response Daily Counts'[Responses]),DATESINPERIOD('Response Daily Counts'[EventDate],LASTDATE('Response Daily Counts'[EventDate]),28,DAY))