Forum Discussion

gianmarco's avatar
gianmarco
Icon for Helper IV rankHelper IV
2 years ago
Solved

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

2 Replies

  • gianmarco try this:

     

    SUM_SALES = CALCULATE(SUM(Sales[Value]), FILTER ( ALL ('Calendar'[Date]), 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) ) )