Next 7 days total measure

[ghosh_kavitha]

Hi Can you help to create measure for  calculate "Next 7 days"total .and the following 7 days total.

example

today date 23/03/2020

i need 23/03/2020  to 30/03/2020 values total

and

31/03/2020 - 6/04/2020 total

Thanks Kavitha Ghosh

[v-yuta-msft · Accepted solution]

@ghosh_kavitha ,

You can also create a measure like pattern below:

Result =
CALCULATE (
    SUM ( Table[Value] ),
    FILTER ( Table, Table[Date] >= TODAY () && Table[Date] < TODAY () + 7 )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ghosh_kavitha]

Thanks for the help..It Works.

Could you help me on the 8th day to 14 th day calculation.

Thanks again

Kavitha ghosh

[az38]

Hi @ghosh_kavitha 

Following 7 days = CALCULATE(SUM(Table[Total]), DATESBETWEEN(Table[Date], TODAY()+8, TODAY()+14) )

[az38]

Hi @ghosh_kavitha 

you need smth like

Next 7 days = CALCULATE(SUM(Table[Total]), DATESBETWEEN(Table[Date], TODAY(), TODAY()+7) )

and 

Following 7 days = CALCULATE(SUM(Table[Total]), DATESBETWEEN(Table[Date], TODAY()+7, TODAY()+14) )