Forum Discussion

srivally's avatar
srivally
Helper I
7 years ago
Solved

consistent top customers

Hi All, Can anyone help me on finding consistent top customers for last 3 years. Regards, Srivalli
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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's avatar
    v-frfei-msft
    7 years ago

    Hi srivally,

     

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


    Regards,
    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

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's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi srivally,

     

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


    Regards,
    Frank