consistent top customers

Hi srivally,

 

I made one sample for your reference, if it doesn't meet your requirement, kindly share your sample data and excepted result to me.

 

Here we need to create two measures to work on it.

 

countlast = CALCULATE(COUNTA(Table1[customers]),FILTER(Table1,Table1[date]<=TODAY() && Table1[date]>=DATE(YEAR(TODAY())-3,MONTH(TODAY()),DAY(TODAY()))))

Measure = TOPN(1,VALUES(Table1[customers]),[countlast])

 

Regards,

Frank

Hi srivally,

 

Does that make sense? If so, kindly mark the answer as solution to close the case.

Regards,
Frank