Can someone help on the request below PLEASEE!!!!!!!!

https://community.powerbi.com/t5/Desktop/Need-help-with-Vlookup-value-in-the-same-datatable-with-multiple/m-p/3096029#M1049937

Hi Community, can someone please help on my request? 

Much appreciated!!!

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.

What I'm trying to achieve is below:
As of Oct/31/2022(data extration date), I have a total of 11 memebership ID, 2 of them(ID: 5 and 6) that their membership exprires on Oct/31/2022, 

When I pulled the data a month later on Nov/30/2022 (data extration date) and append with the date from prevous extration date, since ID 1, 2, 3, 4 did renew their membership, only ID 5, and 6 have been renewed their membership with a new "membership end date" as Nov/30/2023

is there a way (measure or other ways) to achieve: 
calulating the number of ID that did not renew in the latest data extration date? 
in the example above, it would be something like: 4(ID 1,2,3,4) out 6(ID: 1,2,3,4,5,6) that did not renew,
when the membership end date= data extration date.
In other words, I have to write some dax to lookup that ID 1, 2, 3, 4,5,6 from the previous data extration date(oct/31/2022) to see if they show up in the new date extration date (nov/30/2022), only ID 5 and 6 appears in the new data extration (nov/30/2022) because their membership has renewed(now with new membership end date as nov/30/2023 comparing to oct/31/2022 in the previous data extration date) 

see below screenshot for done in excel manually with vlookup.
Thanks in advance for your help!