How do I create an Index for a table based on category and date?

[EsotericPowerBi]

Hello, I am having a hard time trying to figure out how to create an index column for a category based on the date ascending. I've tried grouping the columns and sorting afterwards but nothing has worked so far. Thanks!

[EsotericPowerBi · Accepted solution]

Found the solution in this post. 

https://community.powerbi.com/t5/Desktop/DAX-Ranking-Date/m-p/98237

[EsotericPowerBi]

The picture is what I want the query to look like. Thanks!

[Ahmedx]

maybe so

https://dropmefiles.com/k7CHu