Forum Discussion

Janica123's avatar
Janica123
Helper I
3 years ago
Solved

Cummulative Count

Hi Community I need your help!   I have the following scenario: I have a list of tasks that are related to a sprint. In this tabele ALL tasks (active and closed) are listed. For each Task ID I hav...
active tasks
completed tasks
cummulative
cummulative count
sprint
sprint planning
  • daXtreme's avatar
    daXtreme
    3 years ago

    Hi there. I've created a sample file with the first data set (from the picture as I was too impatient to wait for your data). Please check it out. It should be what you wanted... but let me know if you've got any further questions. File attached.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

hmm if you have a measure for count , try use :

 

All Time COUNT = 
VAR seldate = MAX('Calendar Table'[Date])
VAR firstdate CALCULATE(FIRSTDATE([date]),REMOVEFILTERS('Calendar Table'[Date]))
Return
CALCULATE([measure],DATESBETWEEN('Calendar Table'[Date],firstdate,seldate))

 

this will give you aa stacking of count over each period