Create new column with remaining hours

[Anonymous]

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)

[Greg_Deckler · Accepted solution]

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