Forum Discussion

rmolinajr's avatar
rmolinajr
Frequent Visitor
8 years ago

RANKX WITH DATE

Hi all,

 

I have a problem in ranking with dates for example, I have a slicer between two dates and when the client chooses a period between 2018-01-01 until 2018-01-05, this ranking I already created of the search date, but after that I also need pick the previous period of the chosen slicer that would be, 2017-01-01 until 2017-01-05, this ranking I can not do automatically.

 

You could help me.

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago
    When I test using this measure:
    Measure = RANKX(ALLSELECTED(Sheet1),Sheet1[number2],,DESC)
    I can get correct ranking of both periods for
    2018/1/1-2018/1/5 and 2017/1/1-2017/1/5
     
     
    Best Regards
    Maggie