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. 

     

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!