Forum Discussion

giroldoale's avatar
giroldoale
Icon for Helper I rankHelper I
4 years ago
Solved

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

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
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

2 Replies