Renewal rates

Thank you for your reply,

I'm try to get an output that looks like so:

I think the way to go is to create a table of all of the [user IDs] who have had a card during a specific period, say Jan-18 (which means that their cards would expire Jan-19) and then review that list of user IDs to see which ones now have a new card (with a status of 6) from Jan-19 onwards. 

In short, what percentage of people who originally bought a card in Jan-18 have since renewed. 

I tried the following to give me a table of cards with a particular puchase date but I get the error

"A table of multiple values was supplied where a single value was expected." back.

Table = 
ADDCOLUMNS(
  
        Cards, 
        "Expired Cards", 
        DATESBETWEEN(Cards[timePurchased].[Date], DATE(2014,1,1), DATE(2014,1,31)))