Recurring Memberships based on Unique User IDs

Hi ClaytonL 

Thanks for reaching out to us.

>> The data below is a scrubbed version of what I have. ... I was thinking that a dax measure that looked back one month to see if that userID bought a membership would work but I cannot figure out how to do it. Also, for terminated members, a dax measure could look back one month, see if they bought last month but didn't this month. 

Could you provide your expected outcome based on your sample data? Note: Your sample data should preferably contain all the scenarios involved. For example,

if Service= "Membersship", and if Date .... then measure= ....

if Service= "Basic Membersship", and if Date .... then measure= ....

...

Thanks.

Best Regards,

Community Support Team _Tang

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