Calculated Column for Azure DevOps Completed Work Field

GregAtCatapult — Sun, 25 Jul 2021 20:53:50 GMT

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 Id	Completed Work	Date	Date Previous
5	2	7/23/2021	7/22/2021
5	2.5	7/24/2021	7/23/2021
5	3	7/25/2021	7/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!

Re: Calculated Column for Azure DevOps Completed Work Field

Tanushree_Kapse — Mon, 26 Jul 2021 15:02:14 GMT

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

topic Calculated Column for Azure DevOps Completed Work Field in DAX Commands and Tips

Calculated Column for Azure DevOps Completed Work Field

Re: Calculated Column for Azure DevOps Completed Work Field