Need a measure for the logic stated

[AjithPrasath]

Hi Everyone,

   I have Sprint number column, offshore billable hours(measure) column . I also have constant offshore approved sow(lets say for ex: 11516). I have to create the new measure Remaining hours for calculating as per the below logic:

1. For first sprint alone(Ex: sprint0) I have to subtract offshore approved sow- offshore billable hours for Remaining hours.

2. From next sprint I have to subtract the previous value of the remaining hours  and offshore billable hours of the current row

lets say  offshore approved sow=100. The logic will be like below:

Sprint Number	Offshore Billable hours	Remaining hours
0	10	90(100-10)
1	20	70(90-20)
2	30	40(70-30)

[AjithPrasath]

@wdx223_Daniel  thank you for the timely help!!!

[AjithPrasath]

Hi @wdx223_Daniel ,

  When I tried to implement the above code, it is have small logic issue. For every sprint it is subtracting from the sow. But I need only for first sprint  to implement this logic. from nxt sprint I need to subtract from the previous remaining hr value. Please find the ss below with the above code logic:

For ex: sprint2==>I need 11324-832=10492 like this

           sprint3==> 10492-249=10243 

[wdx223_Daniel · Accepted solution]

Remaining Hours=sow-calculate(sum(table[offshore billable]),table[sprint number]<=max(table[sprint number]),all(table[sprint]))

[wdx223_Daniel]

Remaining Hours=sow-calculate(sum(table[offshore billable]),table[sprint number]<=max(table[sprint number]))