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
tmears
Helper III
Helper III

Weekly Rolling Average 2 weeks before and after

I am at a total lose with this one.  I have been asked to produce 4 week weekly moving average of events covering two weeks before and two weeks after the event date.  I just keep going around in circles!!!  do i need to create a summary table?

 

Any help or pointers would be greatly appriciated

 

Event  Datesalesorderidweek number
15/04/2011 00:00106feb2e-88e9-e811-a8cb-00224801a6a416
20/04/2011 00:00c169f328-88e9-e811-a8cb-00224801a6a417
17/06/2011 00:00146feb2e-88e9-e811-a8cb-00224801a6a425
20/07/2011 00:005679eb2e-88e9-e811-a8cb-00224801a6a430
14/09/2011 00:000f8ceb2e-88e9-e811-a8cb-00224801a6a438
06/10/2011 00:004c7eeb2e-88e9-e811-a8cb-00224801a6a441
14/10/2011 00:000a6ceb2e-88e9-e811-a8cb-00224801a6a442
17/11/2011 00:001a6feb2e-88e9-e811-a8cb-00224801a6a447
22/11/2011 00:000f73eb2e-88e9-e811-a8cb-00224801a6a448
16/12/2011 00:00bf6deb2e-88e9-e811-a8cb-00224801a6a451
28/03/2012 00:00288aeb2e-88e9-e811-a8cb-00224801a6a413
29/03/2012 00:00f16feb2e-88e9-e811-a8cb-00224801a6a413
13/04/2012 00:00fc7eeb2e-88e9-e811-a8cb-00224801a6a415
21/05/2012 00:000774eb2e-88e9-e811-a8cb-00224801a6a421
25/06/2012 00:00ad6deb2e-88e9-e811-a8cb-00224801a6a426
09/07/2012 00:00c56deb2e-88e9-e811-a8cb-00224801a6a428
14/07/2012 00:00db6deb2e-88e9-e811-a8cb-00224801a6a428
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

There are many ways of doing this, here is one example

 

lbendlin_0-1637891877105.png

 

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

There are many ways of doing this, here is one example

 

lbendlin_0-1637891877105.png

 

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.