Filtering Date Results in Two Tables Using User Selected As Of Date

^{Hi julesdude ,}

^{Please follow these steps:}

^{(1) Create a new measure}

FLAG = 
IF (
    MAX ( 'Table1'[Unit Start Date] ) <= MAX ( 'Date'[Date] )
        && (
            MAX ( 'Table1'[Unit End Date] ) >= MAX ( 'Date'[Date] )
                || MAX ( 'Table1'[Unit End Date] ) = BLANK ()
        ),
    1
)

^{(2) Set up filtering}

^{(3) The end result}

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}