Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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) |
Solved! Go to Solution.
Remaining Hours=sow-calculate(sum(table[offshore billable]),table[sprint number]<=max(table[sprint number]),all(table[sprint]))
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
Remaining Hours=sow-calculate(sum(table[offshore billable]),table[sprint number]<=max(table[sprint number]),all(table[sprint]))
Remaining Hours=sow-calculate(sum(table[offshore billable]),table[sprint number]<=max(table[sprint number]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
26 | |
22 | |
13 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |