Forum Discussion

powerbiuser101's avatar
powerbiuser101
Icon for Advocate I rankAdvocate I
8 years ago

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...
Need Help
powerbiuser101's avatar
powerbiuser101
Icon for Advocate I rankAdvocate I
8 years ago

 

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

Seward12533's avatar
Seward12533
Icon for Solution Sage rankSolution Sage
8 years ago

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.