Sum of Next 7 Day Sales

[gillenl]

This is a 2 part question: today is 7/13/22

I am trying to calculate my COGS for the next 7 days based on LY COGS.

I started my measure with trying to calculate LY COGS but as you can see in the photo below they seem to be off by 1 day...what am i doing wrong?

COGS Next 7 =

CALCULATE(

[COGS],

DATEADD('Date'[Date], -1, YEAR))

Once I have that I would like to do a rolling sum of 7 days looking forward.  

so my true COGS Next 7 would equal LY COGS 7/13/22-7/19/22 - 82,858

How do i create that DAX???

PLEASE HELP 🐵

[amitchandak · Accepted solution]

@gillenl , You can get rolling 7 like

Rolling 7 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-7,Day))

Rolling 7 year behind = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAXX('Date', dateadd('Date'[Date], -1, Year) ),-7,Day))