Forum Discussion
Cumulative Count by Date help
Hi, I think I'm very close but I can't figure out the last piece of the puzzle. The solution here might be close but I need : https://community.powerbi.com/t5/Desktop/Cumulative-Count-by-Date/m-p/36...
Hi Seward12533,
Unfortunately no success. When graphed, for example, expectation would be that on June 17th, the value of the red line would be at 4.
I'll look into TOTALMTD. Thanks
You need to build a mesure to calcate cumulative Count of Incomplete either by using the built in TOTALMTD, TOTALYTD or building your own similar to the post you linked to in your original question. Someting like
Cumulative Count of Inc = IF(MIN(Calendar[Calendar_Date])<=NOW(),CALCULATE([Count Inc],FILTER(ALL(Calendar),Calendar[Calendar_Date]<=MAX(Calendar[Calendar_Date]))))
The IF blocks this from calculating for dates in the future assuming your date table does as well.