Ranking a sub group in a column from last to first based off time.

[nathan_kul]

Hi, 

I have the code 

Ranking = RANKX(FILTER(data_set,data_set[customer_ID]=EARLIER(data_set[customer]ID)), data_set[time_stamp],, ASC)

This code ranks the individual customers entries from first to last based off the time stamp. How could I get the output to be the last entry based off time stamp to being ranked first and the first entry based off the time stamp to being ranked last?

Thanks in advance!

[lbendlin]

DESC ?

[nathan_kul]

Yes, descending. How would I input that?

[Irwan · Accepted solution]

@nathan_kul 

Use DESC instead of ASC in your DAX as @lbendlin mentioned above.