Cumulative total that resets to zero on month slicer

[Pmorg73]

Hi. I have a cumulative WIP which I plot with a cumulative budget line. It works great this month April, but when I got to month 2 on my slicer I want it to return to starting at Zero. WIP being the nature of Work in Progress will reset each month, so I need my budget line to reset as well. I am thinking it is using Selected value instead of Allselected, but I can't quite get it to work.

Current cumulative DAX

Daily Budget Line =

  IF(ISBLANK([Sum daily budget]), blank(),

      CALCULATE([Sum daily budget],

          FILTER(ALLSELECTED('00_calendar'[Date] ) ,

                 '00_calendar'[Date] <= MAX('00_calendar'[Date]))))

suggestions please

Phil

[amitchandak · Accepted solution]

@Pmorg73 , I did not get it completely. But if you want reset monthly you use MTD

MTD Sales = CALCULATE([Sum daily budget],DATESMTD('Date'[Date]))

I am hosting a webinar on 25th April on Power BI, Check Details - https://www.linkedin.com/posts/amitchandak78_webinar-tech-techforgood-activity-6658266754378231808-y...

[Pmorg73]

Exactly what I wanted cheers