Forum Discussion

jbakerstull's avatar
jbakerstull
Regular Visitor
3 years ago

Rank [Start Date] in Descending order

I've learned how to create a rank [Start Date] grouped by [Clients Personal ID] in Ascending order from table Client  

 

Formula 

ClientFirstEntry = RANKX(FILTER(Client, Client[Clients Personal ID]=EARLIER(Client[Clients Personal ID])),Client[Start_Date],,ASC ,Skip)
 
Resoule 

Example

Clients Personal ID        Start Date      ClientFirstEntry

3487                                 9/30/22                 1

3487                                 11/1/22                 2

 
Is it possible to possible to rank [Start Date] in Descending order? 
 
Example

Clients Personal ID        Start Date      ClientLatestEntry

3487                                 9/30/22                 2

3487                                 11/1/22                 1

 
I'm not have much success googling for such an example. 
 
Thanks
General Comment
Need Help

2 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Solution Sage
    3 years ago

    Have you tried providing 'DESC' in the place of ''ASC". If so what's the output you got? If not try it that should help to solve your problem. 

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

    • jbakerstull's avatar
      jbakerstull
      Regular Visitor
      3 years ago

      Hi Kishore, 

       

      Replacing "ASC" with "DESC" only switched the rows but not that vaules. Please see below. 

       

      Clients Personal IDStart_DateClientFirstEntryClientlatestEntry
      3487Tuesday, September 20, 202212
      3487Tuesday, November 1, 202221