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 ...
For the attached file I would need a rolling average that only includes dates found in the data and is set by the parameter
If you need anything else please let me know!
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.