Add id and order by older date in a calculated table

[Anonymous]

Hi everyone.

Im creating a calculated table:

 I want to order my table by oldest date to newest date. Actually is not ordered correctly as you can see in the next image:

Then, i want to add id column.

Ty vry much, i hope someone can help me.

[amitchandak]

@Anonymous , You can create a rank, not need to order the table

rankx(filter(Table, Table[month] = earlier(Table[Month]) ) , [Date],,asc, dense)

[Anonymous]

The Table parameter in the filter function has to be my calendar table?

Because i was trying to use the calculated table that im creating but i was not able to do that.

Ty vry much.