Help finding the 10 week average

[wfarrell]

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.

[Anonymous · Accepted solution]

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