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 

I have the newest update - version: 2.88.2361.9 64-bit (January 2021)

I think it is the syntax for the variable which is incorrect for my situation and I am not replacing them correctly, could you please replace them using the following field and table names I am using? Apologies

I am not sure what to put in emp as well

Table: PBIPND_vwPositionPrivate

Start date column name: StartDate

End date column name:  EndDate

Employee number column name: StaffNumber

Date table name: Date Table

Date column name: Date

Thanks for letting me know, I don't have access to this version from my workplace. Any suggestions on workarounds? 

Thanks this seems to be operating, however, runs into an error:

!A circulate dependency was detected: PBIPND_vwPosition_Private[Column], PBIND_vwPosition_Private[Current FTE], PBIPND_vwPosition_Private[Column].

A circular dependencycy was detected:

• PBIPND_vwPosition_Private[Column],
• PBIPND_vwPosition_Private[Current FTE],
• PBIPND_vwPosition_Private[Column].

A column from the Position vw is getting picked up? Actual FTE is a decimal type column

Thank you for your help with troubleshooting, I don't think it is returning the right result: there should be a sum of hundreds of active FTE 

Data facts to support:

• Every employee only ever gets one employee number
• Each employee can have several position records 
• When the slicer is linked to a date table, which is filtered to cap the distinct count of position records per employee number to show the most recent entry within the date filters 
• SUM the most current entry per an employee per the selected date parameters to determine the actual FTE in past or future months of a year

Filter Employee = 
VAR __startDate = MIN ( DateTable[Date] )
VAR __endDate = MAX ( DateTable[Date] )
RETURN
CALCULATE (
    COUNTROWS ( PBIPND_vwPosition_Private ),

    KEEPFILTERS ( 
        PBIPND_vwPosition_Private[StartDate] >= __startDate
    ),
    KEEPFILTERS (
        PBIPND_vwPosition_Private[EndDate] <= __endDate
   ),
   KEEPFILTERS (
        NOT ISBLANK ( PBIPND_vwPosition_Private[EndDate] ) 
    )

)