Forum Discussion
MEverts
3 years agoFrequent Visitor
Employee Utilization Rate - Incorrect Roll-up to month level when calculating Expected Hours
Dear all, I’m calculating employee utilization rates as the proportion of billable hours (actuals), divided by the Expected Hours (projected) minus Leave-hours (actuals): [Billable_Hrs]/([Expected_...
- 3 years ago
Dear all,
I found a solution in the following thread:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Include-Employee-start-and-end-date-in-Utilization/m-p/743723#M2415Best regards, Martijn
MEverts
3 years agoFrequent Visitor
Dear all,
I found a solution in the following thread:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Include-Employee-start-and-end-date-in-Utilization/m-p/743723#M2415
Best regards, Martijn