Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

tracking task completion date slippage from jira data

I need to show which Jira tasks are slipping each week. Jira passes on both start and end dates for tasks (~65 stories) in each project (~100 epics).

I plan to copy the current start and end dates for each task into a history table at the end of each week so that i can catch possible date slippage occurring in the next week.

Is there a smarter way to do this - either using DAX and/or the power bi service.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    I'm not quite sure if I understand your needs accurately. Would you mind telling me a more detailed description of your needs so that I can help you better?

     

    Hope it helps,


    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Caitlyn,

     

    I'm looking to show task slippage from week to week by comparing planned completion dates between current planned completion date - which is what a data refresh will give me - and the planned completion date as it existed in the system last week. For this I need an entry for what last week's date entry was. since the date field gets overwritten with every update, I need to store the original value so that I can retrieve it and compare.

     

    The tasks and dates data are ingested from Jira.

     

    Hopefully this clarifies.