The Timesheets Power Query has been optimized to improve efficiency and maintainability. As part of this update:

▪(simplified the SubmitterResource lookups with a single conditional join;

▪added AssignmentResource as optional supplementary info (resulting in some minor fieldname changes;

▪updated the 'Resources'[ResourceID] 1:* 'Timesheets'[TimesheetResouceUID] mapping; and

▪updated the [_TS-Cost Actual (TSHours x TSRate) measure.