adding an order column to a calculated table

[Jay2022]

I have created a table with dates i want to add a column which orders these dates numerically, 1,2,3 and so on. 

Any help greatly appreciated 

Thanks 

[Anonymous]

Hi @Jay2022 , hello mark_endicott  and lbendlin, thank you for your prompt reply!

Is there any progress on this issue?

If you find anyone's answer is helpful to you, please remember to accept it.

It will help others who meet the similar question in this forum.

If you have any further related issues, please feel free to reply!

[mark_endicott · Accepted solution]

@Jay2022 - Here's an easy way to do this as a calculated table:

Dates = 

VAR _dates = CALENDARAUTO( )

RETURN 
    ADDCOLUMNS( _dates, "Day", DAY( [Date] ))

If this works for you, please accept is as the solution to help with visibility for others with the same issue. 

[lbendlin]

What for? The dates are already usable for sorting?