cancel
Showing results for
Did you mean:
New Member

## 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],

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???

1 ACCEPTED SOLUTION
Super User

@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))

Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines
Super User

@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))

Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors