Forum Discussion

Jay2022's avatar
Jay2022
Icon for Helper IV rankHelper IV
1 year ago
Solved

adding an order column to a calculated table

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 
  • mark_endicott's avatar
    mark_endicott
    1 year ago

    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's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

What for? The dates are already usable for sorting?