Calculate Total Work Hours based on EE Start Date

[justincordasco]

Hi All, 

I have a table that is one column, employee names and the next column employee hire dates. I'm trying to calculate available work hours from each employee's start date through the latest date on my date slicer. 

[Anonymous]

Share sample dataset and expected output.

[Anonymous]

Hi @justincordasco ,

Your slicer is based on a date in a date tabel, otherwise create one.

Make sure you can the workingdays are indicated, 

then a measure like this will get you the workingdays until a certain point in time. They can then be calculated with number available working hours per day.

ExclWorkingDays = 
var EmployeeHireDate = MAX(Employees[HireDate])
var HoursAvailable = CALCULATE (
 COUNTROWS (
 Filter (
 'Dates', 
 Dates[Date] >= EmployeeHireDate && Dates[IsWorkingDay] = "1"
 ) 
 ) * 8 -- hours working per day
 )
return HoursAvailable

hope this helps,

jan