cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pmorg73
Helper V
Helper V

Cumulative total that resets to zero on month slicer

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

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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...

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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...

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

Exactly what I wanted cheers

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.