Get a column value by a date range

Hi SeleneLindsay ,

You can create a calculated column as below in Table2 to get it, please find the details in the attachment.

#GetNameSprint = 
CALCULATE (
    MAX ( 'Table1'[Name] ),
    FILTER (
        'Table1',
        'Table2'[DateEntry] >= 'Table1'[StartDate]
            && 'Table2'[DateEntry] <= 'Table1'[EndDate]
    )
)

Best Regards