Forum Discussion
gianmarco
Helper IV
2 years agoRolling measure /Time Intelligence
Dear All,
i have the following measure:
SUM_SALES = CALCULATE(SUM(Sales[Value]), DATESYTD('Calendar'[Date]))
When I filter for year 2024 or 2025, the sum of sales reset back to 0.
What I need is a measure that won't stop at the end of year but keeps rolling instead.
Should I replace DATESYTD with another function?
Thank you a lot
gianmarco try this:
SUM_SALES = CALCULATE(SUM(Sales[Value]), FILTER ( ALL ('Calendar'[Date]), 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) ) )