Need help with Vlookup value in the same datatable with multiple data extration date

toxicshev  you can use something like this

Measure:=
VAR immediatelyPrecedingExtractionDate =
    CALCULATE (
        [extractionDate],
        ALL ( 'fact' ),
        OFFSET (
            -1,
            ALL ( 'fact'[Data extraction date] ),
            ORDERBY ( 'fact'[Data extraction date], ASC )
        )
    )
VAR _left =
    SUMMARIZE (
        FILTER (
            ALL ( 'fact' ),
            'fact'[Data extraction date] = immediatelyPrecedingExtractionDate
        ),
        'fact'[Membership ID]
    )
VAR __right =
    VALUES ( 'fact'[Membership ID] )
VAR _anti =
    EXCEPT ( _left, __right )
RETURN
    COUNTX ( _anti, [Membership ID] )