How to Create a Static Value from Most Recent Payroll Date?

I'm working to create a measure that will look up the latest payroll date, sum the cost data for that date, calculate a daily cost, and then project future payroll costs based on the daily rate and t...