Forum Discussion

srivally's avatar
srivally
Icon for Helper I rankHelper I
8 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

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    8 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
      Icon for Community Support rankCommunity Support
      8 years ago

      Hi srivally,

       

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


      Regards,
      Frank