Rank by Month and Day

[Puja]

Hi All,

I am trying to get Rank by Month and Date but not able to get it .

DateRank = RANKX(

    FILTER('Slicer Date Table', 'Slicer Date Table'[Month] = EARLIER('Slicer Date Table'[Month]) && 'Slicer Date Table'[Year]= EARLIER('Slicer Date Table'[Year])),

    'Slicer Date Table'[Date]

)

Out put is this:

Here is the sample data

Date	Month	Year
9/15/2023	9	2023
9/29/2023	9	2023
10/1/2023	10	2023
10/15/2023	10	2023

TIA

[ThxAlot]

Weird, the dates themselves are ordinal and enough for sorting. Why bother to use year and month?