Forum Discussion
Solved
Sum 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 2...
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 ) ).
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 ) )
.
Thx so much for the help . Works perfect 🙂