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 ...
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