Forum Discussion
Moving average excluding weekends and holidays
Hi AlB,
Thank youf for the help so far! So I've created the table for our corporate calendar. How would I now, based on the a formula within DAX, be able to create that rolling average based on the new corporate calendar I've created? Essentially, how do I get to the point where I can filter to where only the days from my sales table that appear on the corporate calendar will be included in the moving average. Please let me know what other info you need.
Thank!
Community ChampionAnonymous
Do you want the moving average per [Sales Location] and [Group]? Cause I see you have the ALLEXCEPT for those two columns
AlB Correct, I'm looking for the moving average by location and group. What additional would I need to add in order to have the average calculated for only working days?
Thanks!
- AlB
Anonymous
Hang on... the table that you are showing, the one with the data, does it include weekends, holidays, company holidays as well? If so, what is the value of [Daily Count] on those days? Is it a blank(), a valid value that you just want to ignore?
AlB The table that I have listed up there only includes working days (everything but weekends and corporate holidays).