Sum 5 days later

[Wresen]

Hi

I have a problem that i cant solve.

I have a tabel with dates and sales, and i want to be able to see the sales with a lag of 5 days.

So the the sales on 2023-09-01 should be counted shown on 2023-09-06 as shown in the picture (red column).

It needs to be a measure.

Thx so much for any help or suggestion .

[jdbuchanan71 · Accepted solution]

Two measure will do it.  The first one to sum the sale amount

Sales Amount = SUM ( YourTable[Sales] )

Then one to offset the calculation by 5 days

Sales +5 days = 
CALCULATE ( [Sales Amount], DATEADD ( YourTable[Date], -5, DAY ) )

.

[Wresen]

Thx so much for the help . Works perfect 🙂