Forum Discussion

GregAtCatapult's avatar
GregAtCatapult
New Member
5 years ago

Calculated Column for Azure DevOps Completed Work Field

I would like to track the number of hours per day I am logging on a work item in Azure DevOps. My strategy is to create a calculated column that tracks the difference in the amount of work between a date and the previous day.

 

Here's an example of the data I am using from a table called 'Tasks':

Work Item IdCompleted WorkDateDate Previous
527/23/20217/22/2021
52.57/24/20217/23/2021
537/25/20217/24/2021

 

I created a calculated column for the previous day that uses the following code (per here😞

 

Date Previous =
CALCULATE (
    MAX ( 'Tasks'[Date] ),
        ALLEXCEPT( 'Tasks', 'Tasks'[Work Item Id] ),
        'Tasks'[Date] < EARLIER ( 'Tasks'[Date] )
)

 

 

I now would like to create a calculated column that shows the difference in completed work from the previous date.

 

Please let me know if you have any ideas or tips to help me move in the right direction.

 

Thank you!

  

1 Reply

  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    Impactful Individual
    5 years ago

    Hi GregAtCatapult ,
    You can create a measure to calculate the work completed on previous day and can subtract it form the current day.
    PrevDaywork= CALCULATE(SUM(Tasks[Completed Work]), PREVIOUSDAY( Tasks[Date]))

    Diff=  CALCULATE(SUM(Tasks[Completed Work])- PrevDaywork

     

    I guess this is what you need.
    If it answers your question, mark it as a solution.

    Thanks