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 User
See attached
I need the weekends to not count in the equation if possible, that was where I was having the most trouble. For example, if X equals 10 6/28/2024 should average the previous 10 existing figures to 6/14/2024. Weekend figures shouldn't be present
- lbendlin
What is your definition of weekend? What if there is a weekend day with data ? What if there is a weekday without data?
Sorry for the confusion but the data does not include weekends (Saturday or Sunday) or holidays. I would like to not count those, preferably by only counting which days are provided.
- lbendlin
Do you need the column or row totals? They would be much more complex to get accurate with your new rules.
see attached.