acumulated of the last week but not today

[pakovic]

this instruction calculate the acum of 7 days today included.

I would like to know the last 7 days, but not today, for example, today is Sunday, from past Sunday to Yesterday (Saturday)

Someone help me?  thank you very much

Total month =

CALCULATE([litros salida];

DATESINPERIOD(Calendario[Date];

MAX(Calendario[Date]);

-7;

DAY))

[Fowmy · Accepted solution]

@pakovic 

Try adding -1 to MAX date,

Total month =
CALCULATE([litros salida];
DATESINPERIOD(Calendario[Date];
MAX(Calendario[Date])-1;
-7;
DAY))

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[amitchandak · Accepted solution]

@pakovic , try like

Rolling 7 days = CALCULATE(sum(Sal[Sales Amount]),DATESINPERIOD('Date'[Date],max(Sales[Sales Date])-1 ,-7,Day))

Rolling 7 days = CALCULATE(sum(Sal[Sales Amount]),DATESINPERIOD('Date'[Date],today() -1 ,-7,Day))

[Fowmy · Accepted solution]

@pakovic 

Try adding -1 to MAX date,

Total month =
CALCULATE([litros salida];
DATESINPERIOD(Calendario[Date];
MAX(Calendario[Date])-1;
-7;
DAY))

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn