Rank [Start Date] in Descending order

[jbakerstull]

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

[Kishore_KVN]

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]

Hi Kishore, 

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

Clients Personal ID	Start_Date	ClientFirstEntry	ClientlatestEntry
3487	Tuesday, September 20, 2022	1	2
3487	Tuesday, November 1, 2022	2	1