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. 

     

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago

    What for? The dates are already usable for sorting?

  • mark_endicott's avatar
    mark_endicott
    Icon for Super User rankSuper User
    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. 

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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!