Most Recent Field Based on Date

Hi. I am trying to create a table to show candidate name / Location info / total hours - I need a slicer for date range and I need one line per candidate but they can work in many locations so I need...