Moving Average - Weekdays only

[Anonymous]

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] ) )

[jthomson]

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]

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.