Solved: Re: Sum 5 days later

Wresen · ‎10-13-2023

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 · ‎10-13-2023

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

.

jdbuchanan71 · ‎10-13-2023

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 · ‎10-13-2023

Thx so much for the help . Works perfect 🙂

Sum 5 days later