Retrive Status From other table using Date range

Hi TaufikMaggangka 

Are the two tables linked via ID column? Are you looking for a measure or a calculated column?

TaufikMaggangka 
Yes you are right, I did it the other way around which was wrong.

Please refer to attached sample file with the solution

Position = 
VAR T1 = RELATEDTABLE ( 'Table 1' )
VAR T2 =
    FILTER (
        T1,
        VAR CurrentAttendanceDate = 'Table 2'[Attendance Date]
        VAR CurrentJoiningDate = 'Table 1'[Joining Date]
        VAR T3 = FILTER ( T1, 'Table 1'[Joining Date] > CurrentJoiningDate )
        VAR NextJoiningDate = COALESCE ( MAXX ( T3, 'Table 1'[Joining Date] ), TODAY ( ) )
        RETURN
        CurrentAttendanceDate >= CurrentJoiningDate
            && CurrentAttendanceDate < NextJoiningDate
    )
RETURN
    MAXX ( T2, 'Table 1'[Position] )