LOOKUPVALUE within a range

evebarratt  you can write a measure like this

Measure =
VAR _date =
    MAX ( 'Table 2'[Date] )
VAR _date2 =
    _date - TIME ( 0, 0, 2 )
VAR _date3 =
    _date + TIME ( 0, 0, 2 )
VAR _date4 =
    _date - TIME ( 0, 0, 1 )
VAR _date5 =
    _date + TIME ( 0, 0, 1 )
VAR _return1 =
    CALCULATE (
        MAX ( 'Table 1'[Created By] ),
        TREATAS (
            CROSSJOIN ( VALUES ( 'Table 2'[ID] ), { _date } ),
            'Table 1'[ID],
            'Table 1'[Date]
        )
    )
VAR _return2 =
    CALCULATE (
        MAX ( 'Table 1'[Created By] ),
        TREATAS (
            CROSSJOIN ( VALUES ( 'Table 2'[ID] ), { _date2 } ),
            'Table 1'[ID],
            'Table 1'[Date]
        )
    )
VAR _return3 =
    CALCULATE (
        MAX ( 'Table 1'[Created By] ),
        TREATAS (
            CROSSJOIN ( VALUES ( 'Table 2'[ID] ), { _date3 } ),
            'Table 1'[ID],
            'Table 1'[Date]
        )
    )
VAR _return4 =
    CALCULATE (
        MAX ( 'Table 1'[Created By] ),
        TREATAS (
            CROSSJOIN ( VALUES ( 'Table 2'[ID] ), { _date4 } ),
            'Table 1'[ID],
            'Table 1'[Date]
        )
    )
VAR _return5 =
    CALCULATE (
        MAX ( 'Table 1'[Created By] ),
        TREATAS (
            CROSSJOIN ( VALUES ( 'Table 2'[ID] ), { _date5 } ),
            'Table 1'[ID],
            'Table 1'[Date]
        )
    )
VAR _x =
    MAX ( MAX ( MAX ( MAX ( _return1, _return2 ), _return3 ), _return4 ), _return5 )
RETURN
    _x