Running Average Problem

Hi,

I have the following which metric which gives me a running average per day.

=RunningAverage(Average([var_Port Performance - Turn Time (Days)]))

However, the problem I having is when I filter for the last 7 days, my running average will start from the Day-7, but I want it to start the runningaverage from the first day of the month even when my table is filtered to only show the last 7 days.

My date variable is [var_Day]

So, I want the running average to be

Between (RelativeDate([var_Day];-DayNumberOfMonth([var_Day])+1);[var_Day]))

and still have my 7 day filter.

Anybody know how I can get around this?

Thanks