Group by most recent date, then next most recent, etc

[JoeCochran]

Hello! I'm trying to convert a set of disparate dates into numbers (or indicators - text is fine) indicating the most recent in a group, next most recent in a group, etc. For instance:

turn this:

Store	Date
A	9/1/2019
A	5/1/2019
A	3/1/2019
A	1/1/2019
B	8/1/2019
B	7/15/2019
B	6/3/2019
B	4/1/2019
C	7/16/2019
C	6/1/2019
C	5/1/2019
C	4/1/2019
D	2/1/2019
D	1/1/2019
D	12/15/2018
D	11/1/2018

into this:

Store	Date
A	1
A	2
A	3
A	4
B	1
B	2
B	3
B	4
C	1
C	2
C	3
C	4
D	1
D	2
D	3
D	4

I get the sense that this will be accomplished through the group by function - but I can't figure out how! I'm open to M or Dax solutions! Thanks!

[Zubair_Muhammad · Accepted solution]

@JoeCochran 

You can rank the dates for each store

Calc Column =
RANKX ( FILTER ( TableName, [Store] = EARLIER ( [Store] ) ), [Date],, DESC )