DAX to Include Someone in Average After their Hire Date Using Date Range Filter

Hi,

I am trying to find the average number of hours worked per pay period for a group of employees. If I have a Relative Date filter over the last year, my average is currently counting in the 0 hours (non-existing recorded time rows) for people who were not hired until less than a year ago. I would like to count these people in the average but only include them on and after their hire date.

I have a table that records the submitted timesheets that is connected to another table with employee information. For sensitivity purposes, I will call them Employee Time table and Employees table. Note: In the Employees Table, I have a column with [Hire Date] that gives employees hire dates. I do also have a date table = CALENDARAUTO()

First, in the Employee Table, I have the following measure:

[SumOfPersonnel] = CALCULATE(COUNT(Employee[EmployeeID]), FILTER(Employee, Employee[Active?] = "Active"))

To get the average now, I write the following measures in the Employee Time table:

1. [HRsQuantity] =

VAR MaxDate = MAX(Dates[Date])
RETURN
CALCULATE(SUM('Employee Time'[HoursQuantity]), FILTER('Employees Time', 'Employees Time'[PostingPeriod] <= MaxDate))

2. [AverageTimeAll] = DIVIDE([HRsQuantity], [SumOfPersonnel])

3. [PayPeriodCount] = CALCULATE(DISTINCTCOUNT('Employee Time'[PayPeriod]))

4. [SelectPeriodAvg] =
VAR AvgInPeriod = [AverageTimeAll]/[PayPeriodCount]
RETURN
IF(AvgInPeriod > 0, AvgInPeriod, 0)

I would appreciate the help finding where to implement the [Hire Date] to include Employees in the [SelectPeriodAvg] measure on and after their start date (regardless of date filter).

Looking forward to the help.
Connor