Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
Solved! Go to 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
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
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |