Forum Discussion
Moving Average - Weekdays only
Hello - I am trying to create a moving average for docs sent out. I have the Moving Average formula worked out, but instead of including every day in my MA, I want to get the MA of only weekdays...
Make a calculated column in your date table, either using Date.DayOfWeek in the query editor or WEEKDAY in data view and add filter on the relevant values?
Are you referring to adding the filter into my MA formula, if so, how would I implement that filter in? I have already created my 'Weekday' column into my Calendar table where the weekends (Saturday and Sunday) are days 6 and 7.