cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
wfarrell Regular Visitor
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.

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
clokeshreddy Regular Visitor
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

1 REPLY 1
clokeshreddy Regular Visitor
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