Hourly Payroll Rate for Timesheet Entry

[chervochon]

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.

[v-yetao1-msft]

Hi @chervochon 

How to calculate the ‘Hour Rate’ ? Is the user name corresponding to the Hour rate in the Payroll table unique ? The same question, are the user names corresponding to ‘DurationHours’ in the Timesheets table unique ?

What is the final result you want, could you give me an example?

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.