consistent top customers

[srivally]

Hi All,

Can anyone help me on finding consistent top customers for last 3 years.

Regards,

Srivalli

[v-frfei-msft · Accepted solution]

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

[v-frfei-msft · Accepted solution]

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

[v-frfei-msft · Accepted solution]

Hi @srivally,

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

Regards,
Frank