Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 (Monday-Friday).  How can I do that?  Below is my current MA DAX which includes weekends as well.

 

Thanks!

Ryan

 

 

Moving Average = IF(ISBLANK( [Total Docs Sent] ),
BLANK(),
AVERAGEX(
   DATESINPERIOD(
     Calendar[Date],
   LASTDATE(Calendar[Date] ),
   -'Moving Average What If'[MA Days], DAY ),
   [Total Docs Sent] ) )

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

    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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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.