Sum of Next 7 Day Sales
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 🐵
