topic adding an order column to a calculated table in DAX Commands and Tips

adding an order column to a calculated table

Jay2022 — Thu, 07 Nov 2024 14:53:37 GMT

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

lbendlin — Thu, 07 Nov 2024 16:16:28 GMT

What for? The dates are already usable for sorting?

mark_endicott — Thu, 07 Nov 2024 16:39:29 GMT

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 — Mon, 11 Nov 2024 10:00:46 GMT

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!