Forum Discussion
giroldoale
Helper I
Helper ICreate 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
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
- SpartaBI
Community Champion
giroldoale something like:
CALCULATE([@Qty_Planned],CalendarVersamentoEOP[Date].[Date] <= MAX(CalendarVersamentoEOP[Date].[Date])) 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.
