Rolling 28 Day Measure

Question

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))

greg_deckler · Answer

Please post data in text form.&nbsp;Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
&nbsp;
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

jofoster · Answer

Here is my data again in an easier format to consume.&nbsp;&nbsp;&nbsp;EventDateServiceIsUserInternalPromptsResponsesCommentCount2019-10-22&nbsp;00:00:00.0000000Boards0129691132019-10-22&nbsp;00:00:00.0000000Boards12471212019-10-23&nbsp;00:00:00.0000000Boards0123390102019-10-23&nbsp;00:00:00.0000000Boards1196902019-10-24&nbsp;00:00:00.0000000Boards0120093142019-10-24&nbsp;00:00:00.0000000Boards1205512019-10-25&nbsp;00:00:00.0000000Boards0105575142019-10-25&nbsp;00:00:00.0000000Boards1193512019-10-26&nbsp;00:00:00.0000000Boards0701142019-10-26&nbsp;00:00:00.0000000Boards138102019-10-27&nbsp;00:00:00.0000000Boards0105722019-10-27&nbsp;00:00:00.0000000Boards113002019-10-28&nbsp;00:00:00.0000000Boards0128692162019-10-28&nbsp;00:00:00.0000000Boards1175302019-10-29&nbsp;00:00:00.0000000Boards0123293112019-10-29&nbsp;00:00:00.0000000Boards12061102019-10-30&nbsp;00:00:00.0000000Boards0128093182019-10-30&nbsp;00:00:00.0000000Boards11921032019-10-31&nbsp;00:00:00.0000000Boards1204912019-10-31&nbsp;00:00:00.0000000Boards011968982019-11-01&nbsp;00:00:00.0000000Boards088766122019-11-01&nbsp;00:00:00.0000000Boards1188602019-11-02&nbsp;00:00:00.0000000Boards077412019-11-02&nbsp;00:00:00.0000000Boards123102019-11-03&nbsp;00:00:00.0000000Boards0106702019-11-03&nbsp;00:00:00.0000000Boards116102019-11-04&nbsp;00:00:00.0000000Boards013589292019-11-04&nbsp;00:00:00.0000000Boards1216912019-11-05&nbsp;00:00:00.0000000Boards1228402019-11-05&nbsp;00:00:00.0000000Boards01368120182019-11-06&nbsp;00:00:00.0000000Boards0125088172019-11-06&nbsp;00:00:00.0000000Boards12161012019-11-07&nbsp;00:00:00.0000000Boards0125087202019-11-07&nbsp;00:00:00.0000000Boards1205802019-11-08&nbsp;00:00:00.0000000Boards0106978162019-11-08&nbsp;00:00:00.0000000Boards1180912019-11-09&nbsp;00:00:00.0000000Boards129002019-11-09&nbsp;00:00:00.0000000Boards081632019-11-10&nbsp;00:00:00.0000000Boards115202019-11-10&nbsp;00:00:00.0000000Boards099912019-11-11&nbsp;00:00:00.0000000Boards1211702019-11-11&nbsp;00:00:00.0000000Boards0121973112019-11-12&nbsp;00:00:00.0000000Boards01359104202019-11-12&nbsp;00:00:00.0000000Boards1204822019-11-13&nbsp;00:00:00.0000000Boards0128484192019-11-13&nbsp;00:00:00.0000000Boards11991022019-11-14&nbsp;00:00:00.0000000Boards01218100172019-11-14&nbsp;00:00:00.0000000Boards1215512019-11-15&nbsp;00:00:00.0000000Boards1162302019-11-15&nbsp;00:00:00.0000000Boards0100078132019-11-16&nbsp;00:00:00.0000000Boards01081212019-11-16&nbsp;00:00:00.0000000Boards132212019-11-17&nbsp;00:00:00.0000000Boards0112902019-11-17&nbsp;00:00:00.0000000Boards12320

jofoster · Answer

Thanks for the tips.&nbsp; I copied the data into the post. I could not figure out how to add attachments...perhaps that is not allowed in this forum. Thanks for your help. I looked at your other thing and I could not make the jump to solve my problem.

Forum Discussion

Rolling 28 Day Measure

Related content

30 days rolling

Rolling 12M Average measure

Rolling accumulation

Rolling accumulation

3 Day Rolling Average - DAX