Create e Cumulative SUM from a specific date to Today's date

[giroldoale]

Hi,

I would like to build a measure that calculates a cumulative sum from a specific date in the past up to Today's date.

Up to now I've been able only to write this script:

CALCULATE([@Qty_Planned],DATESYTD(CalendarVersamentoEOP[Date].[Date]))

but the measure restart every year and do not stop into Today's date.

How to avoid this "restart" of a Year To Date cumulative sum formula?

Thanks for help

[v-eqin-msft · Accepted solution]

Hi @giroldoale ,

Please try:

Measure = CALCULATE([@Qty_Planned],FILTER('Table',[Date]>=DATE(2021,9,30) && [Date]<=TODAY()))

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SpartaBI]

@giroldoale something like:
CALCULATE([@Qty_Planned],CalendarVersamentoEOP[Date].[Date] <= MAX(CalendarVersamentoEOP[Date].[Date]))

      

Showcase Report – Contoso By SpartaBI