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

Hi Everyone, I've been struggling with this for awhile, and I cant seem to figure out how to solve this in DAX. I need help! A table below is my dataset that contains data from 2 extration date....

Need Help

smpa01

3 years ago

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] )