cancel
Showing results for
Did you mean:
Regular Visitor

## Help finding the 10 week average

Hello,

I am trying to find the 10 week average for Leads and TotalLeadCost columns.  Below is what my data looks like. I would like to find the 10 week average for each column. If I can do this with one calculation that would be great. But it's okay if I cannot do it with just one calculation. If you need me to send raw data I can do that.

Any help is greatly appreciated.

-William F.

1 ACCEPTED SOLUTION

Accepted Solutions
Regular Visitor

## Re: Help finding the 10 week average

Hi @wfarrell,

You can use the below formula to compute the 10 week Average.

Week Avg =
CALCULATE (
SUM ( Sales[Revenue] ),DATESINPERIOD('Calendar'[Date],LASTDATE('Calendar'[Date]),-70,DAY))/10

Regards

CLR

Regular Visitor

## Re: Help finding the 10 week average

Hi @wfarrell,

You can use the below formula to compute the 10 week Average.

Week Avg =
CALCULATE (
SUM ( Sales[Revenue] ),DATESINPERIOD('Calendar'[Date],LASTDATE('Calendar'[Date]),-70,DAY))/10

Regards

CLR