Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
wfarrell
Frequent 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
Anonymous
Not applicable

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.