How to rank by month and year?

[Anonymous]

Good afternoon! 

Could you help me with measure to sort by "year & month" ascending?

Now it doesn't work as  wish to get

I want to get the next: 
202201 - 1

202202 - 2
...

202303 - 13
and so on
dax file:

https://disk.yandex.ru/d/B1gobUijeWcvDw   

[v-jianboli-msft]

Hi @Anonymous ,

Please try:

RangeMonthYear = 
var _a = RANKX(ALL('Календарь'),[Сорт Год_Мес],SELECTEDVALUE('Календарь'[Сорт Год_Мес]),ASC,Dense)
return SELECTEDVALUE('Календарь'[Сорт Год_Мес])&" - "&_a

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[eliasayyy]

hello i have another work around create a month id new column to the atbel 

Month ID = 
VAR _min = YEAR(MIN('Table'[Date]))
RETURN
MONTH('Table'[Date]) + (YEAR('Table'[Date]) - _min) *12