Forum Discussion
Cumulative Report / Project Hours
Hi JS27 ,
To get exactly the same output as you expected, it could be complicated and create multi simliar measures:
Hours Exec May 2020 = CALCULATE ( SUM ( 'Activity Report'[Hours Exec] ), FILTER ( 'Activity Report', 'Activity Report'[Date].[MonthNo] = 5 ) ) Hours Not Prof Exec May-2020 = CALCULATE ( SUM ( 'Activity Report'[Hours Not Prof Exec] ), FILTER ( 'Activity Report', 'Activity Report'[Date].[MonthNo] = 5 ) ) Backlog Hours Exec May 2020 = SELECTEDVALUE('Budget'[Budget Hours]) - [Hours Exec May 2020] Backlog Hours Not Prof Exec May 2020 = SELECTEDVALUE(Budget[Budget Hours Not Profitable]) - [Hours Not Prof Exec May-2020]Sample file is attached: Cumulative Report / Project Hours.pbix
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi JS27 ,
To get exactly the same output as you expected, it could be complicated and create multi simliar measures:
Hours Exec May 2020 =
CALCULATE (
SUM ( 'Activity Report'[Hours Exec] ),
FILTER ( 'Activity Report', 'Activity Report'[Date].[MonthNo] = 5 )
)
Hours Not Prof Exec May-2020 =
CALCULATE (
SUM ( 'Activity Report'[Hours Not Prof Exec] ),
FILTER ( 'Activity Report', 'Activity Report'[Date].[MonthNo] = 5 )
)
Backlog Hours Exec May 2020 = SELECTEDVALUE('Budget'[Budget Hours]) - [Hours Exec May 2020]
Backlog Hours Not Prof Exec May 2020 = SELECTEDVALUE(Budget[Budget Hours Not Profitable]) - [Hours Not Prof Exec May-2020]
Sample file is attached: Cumulative Report / Project Hours.pbix
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
That's works perfectly v-yingjl , thank you very much!
One thing, Is it possible to have a backlog total for each month not taking into consideration the Project in Detail? I mean, trying to minimize the amount of measures that i need to create to get this done, using the same dataset.
Something like:
| Month | Backlog Hours | Backlog Not Profitable |
| May 2020 | 275 | 35 |
| June 2020 | 240 | 22 |
Regards.