Forum Discussion

Nicho247's avatar
Nicho247
Icon for Helper III rankHelper III
6 years ago

Cumulative Total Help - Slicer sets starting date

Hello -    Working on a basic running/cumulative total. I have it working but it is grabbing all dates in my table. I'd like it to compute starting from the date present in a slicer. I've poked aro...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Nicho247 , Make sure you have all the dates in your calendar. Try


Cumulative OnTime =
calculate(COUNTROWS(WKO),
FILTER(all(WKO), WKO[CompletedDate] <= MAX('Calendar'[Date])))

or

Cumulative OnTime =
calculate(COUNTROWS(WKO),
FILTER(allselected(WKO), WKO[CompletedDate] <= MAX('Calendar'[Date])))

Nicho247's avatar
Nicho247
Icon for Helper III rankHelper III
6 years ago

Bummer. Neither of those work. No different than what mine was doing, but both drop the ability to breakdown the running total by legend (aka only 1 line).

 

The beginning of my dataset on WKO table is 1.1.2019.

 

Here is pic1.  My date slicer also reads 1.1.2019. Cumulative totals on all start at 0.

 

Here is pic2. My date slicer has been changed to 1/1/2020. Cumulative totals should start at 0 but dont.