How to determine which is the current record between multiple records for an employee

Thanks so much Parry2k for your help with this

I am running into a couple of issues

• My employee table with an employee number, position start date and position end date is called Sheet1
• My date table dimension table: [date] date table

Scenario

• Every employee has a position record with a start date
• Some employees may have multiple position records over time 
  • No two-position records per an employee can have an overlapping start date
• I need to identify using a data slicer with month and years (from date table) which is the active position record for the employee at a moment in time so I can only ever see a maximum of one position record per an employee 
• I am not sure how to do this - I am trying to identify one active position record amongst multiple inactive and (1) active postion per an employee