Forum Discussion
Wresen
Post Patron
Post PatronSum 5 days later
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 .
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 ) ).
2 Replies
- jdbuchanan71
Super User
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 ) ).
WresenThx so much for the help . Works perfect 🙂