Calculated Column for Azure DevOps Completed Work Field

[GregAtCatapult]

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!

[Tanushree_Kapse]

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