Forum Discussion

tpal415's avatar
tpal415
Frequent Visitor
6 years ago

Employee Utilization - incorrect totals

I am trying to figure out how to build a formula that will provide the utilization for multiple employees reporting different billable hours and also with different working hours due to when they sta...
Need Help
tpal415's avatar
tpal415
Frequent Visitor
6 years ago

Greg_Deckler 

 

Still haven't quite figured out how to incorporate start and end dates into total work hours for each employee using your utilization formula. I bought and read through the utilization chapters within your book, but cannot see an explanation on how to calculate work hours by individual employee, only an aggregation of total possible working hours. Any help would be appreciated!

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

tpal415 - See if this helps, attached PBIX from my other book, Learn Power BI which goes through the whole utilization stuff in detail.

 

I am thinking maybe:

Total Hours = 
    VAR __Start = MAX('Employee Table'[Start Date]),
RETURN
    switch(max('2 Hours'[Column]),
    "Full-Time", SUMX(FILTER('Work Hour Calendar',[Date]>__Start),[Work Hours]),
    blank()
)

Something like that.