Hourly Payroll Rate for Timesheet Entry

I have two tables of data, one is payroll data with a calculated wage rate (Payroll Amount/Earnings Hours) and timesheet data with associated dates and hours. The payroll dates are every two weeks to correspond to how often the employees get paid. The timesheet data is daily, most times with multiple entries per day.

Problem I am trying to solve:

Calculate the labor cost (Hourly Rate * DurationHours) for each row in the timesheet data based on the UserName/Employee. The hourly rate should be the rate that was in effect as of the date of the timesheet date. In other words, I can't just use MAXX to pull the most recent Hourly Rate.

Data:

Payroll

Timesheets:

I thought I needed to use MULTIPLYX but after some research I see that isn't an actual DAX function. Any help would be much appreciated.