Forum Discussion
Create new column with remaining hours
I need to calculate remaining hours left in a PO by contractor by month for each month of a fiscal year in a new column. Each month has a different number of working hours available and different end dates. Will this work?
New Column Dec Remaining Hours
Dec Remaining Hours = IF('Sep-Jun 2018 Burn Down'[End Date]>=DATEVALUE(12/31/2017),'Sep-Jun 2018 Burn Down'[ PO Hours]-('Sep-Jun 2018 Burn Down'[FY18 YTD Hours Wrk]+152)
(152 hours available to work in Dec)
New Column Jan Remaining Hours
Dec Remaining Hours = IF('Sep-Jun 2018 Burn Down'[End Date]>=DATEVALUE(1/31/2018),'Sep-Jun 2018 Burn Down'[ PO Hours]-('Sep-Jun 2018 Burn Down'[FY18 YTD Hours Wrk]+152+168)
(152 hours available to work in Dec and 168 hours available to work in Jan)
Source data example that can be copied and pasted would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
1 Reply
- Greg_DecklerCommunity Champion
Source data example that can be copied and pasted would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490