Last 4,12 and 26 week Sales

[Anonymous]

Hello,

I have 2 columns in my sheet sales amount and weekending date. I need to calculate sales amount for last 4 weeks, 12 weeks and 26 weeks and compare the same with previou year last 4 weeks, 12 weeks and 26 weeks. I tried few ways looking at similar posts before and looks like it is not working. I need to calculate it based on weeknumber because the iso week number for a given date this year is different to previous year same date value. Attaching the excel and pbix files. So for weekending 2/25/18 last 4 week sales amount should be 275 and last 12 weeks is 780 and Last 4 weeks previous year is 280. Appreciate the help.

[Anonymous]

https://www.dropbox.com/s/1hpivjyltjoy6pm/4WeekCalculation.xlsx?dl=0

https://www.dropbox.com/s/3m8ftuzp4snlhg2/Last4weekSales.pbix?dl=0

[Ashish_Mathur]

Hi,

As far as i can tell, there is no ISOWEEKNUM() function in the Query Editor or the PowerPivot.  May be someone else can shed some light on this.

[Anonymous]

If not ISOWeek may be regular weeknum will work too.  

[Ashish_Mathur]

Hi,

You may download my solution from here.

Hope this helps.