Select customers where membership expired in the last 90 days

[EVEAdmin]

Hi all,

on a table, I have a column for the Customer ID and a Column for the licence expiry date.

What I would like to do is extract the list of CustomersID where the membershop expired during the past 90 days.

I created a first quick measure which will select the max date for each customer:

LatestExpiry = 
MAXX(
	KEEPFILTERS(VALUES('Items'[InCustID])),
	CALCULATE(MAX('Items'[ExpiryDate]))
)

Then, I created a second measure that should return only those records where the max expiry date is in the past 90 days

ExpiredLast90Days = IF(TODAY()>[LatestExpiry] && DATEDIFF(TODAY(),[LatestExpiry],day)<=90,1,0)

but it does not work as intended. Any help, please?

[EVEAdmin · Accepted solution]

I changed the second measure as follows and now it works

ExpiredLast90Days = IF(TODAY()>[LatestExpiry] && [LatestExpiry]>= TODAY()-90 ,1,0) 

[Anonymous]

Is there a way to show Customer IDs where the expired date is NOT in the last 30,60, 90 days etc.?