Forum Discussion

Janica123's avatar
Janica123
Icon for Helper I rankHelper 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.

daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
3 years ago

Hi Janica123 

 

This data you've pasted... I can see it's not consistent. There are tasks without an activation date but with a closed date. There are tasks which span more than 1 sprint. There are many questions to be asked about this data. For instance, one of them would be: How should one treat tasks without an activation date? Should such data not be first cleansed in Power Query to make it... well, logical, consistent and ready for consumption by Power BI?

Janica123's avatar
Janica123
Icon for Helper I rankHelper I
3 years ago

Hi daXtreme ,

thank you very much for your effort!! Yes, your right I've inserted the wrong sample and all the tasks have an activation date, sorry for that. I've corrected it now in the post. 

Regarding the fact that the tasks span more than one sprint, this is correct. In the use case they work with sprints with a length of 2 weeks thats why the "Sprint CW" is most often in this form. This means also, that the time span I'd like to look at are the respective dates of those two calendar weeks selected.