Forum Discussion
Rolling average with adjustable time frame
I'm having issues creating a measure to calculate the average over the past X days for a specific account. In the initial Data I have multiple rows per day for several accounts with a specific value ...
lbendlin
Super User
Super UserDo you need the column or row totals? They would be much more complex to get accurate with your new rules.
see attached.
Thanks that's perfect. I do not need row or column totals. The only total I need is to compare the calculated average and the current day value, then count the amount of times the current day exceeds the calculated average (for each account, not summed across for the day). These are example numbers but we're creating a threshold for a lookback period to present. We need to compare the amount of threshold breaks with the size of the lookback period.