14 day
1 Topic
14 day rolling sum
Apologies in advance if this is confusing: I have 2 dates: Notification date and Epi Date What im trying to do is get a rolling 14 day sum of each. I have tried this but it keeps giving me numbers that are way off: 14 Day Rolling Average - Notification Date = CALCULATE(SUM('Sheet1'[Epi Date]),DATESINPERIOD('Sheet1'[Event Date],LASTDATE('Sheet1'[Event Date]),14,DAY)) / CALCULATE(DISTINCTCOUNT('Sheet1'[Event Date]),DATESINPERIOD('Sheet1'[Event Date],LASTDATE('Sheet1'[Event Date]),14,DAY)) Can anyone help with this? Many thanks in advance SEE FILE ATTACHED https://www.dropbox.com/s/vzbztfgwq9370nq/Notification%20vs.%20Epi.pbix?dl=0Solved5.1KViews0likes2Comments