Forum Discussion
Tob_P
3 years agoHelper V
Sequence Date Column - Power Query
I have a standard date column for Shipments - formatted as Date/Time with multiple entries for each date.
I would like to add a sequence/index column in Query Editor to sort these dates. The reason why I need to do this rather than just sort by date in a visual, is that I have a calculated column that prefixes the date with the day name eg.
Monday - 28/11/2022
...and when I drop that column into my table, it won't sort sequentially, so need the column suggested above so I can sort by that column.
Is this possible?
No need to reply - was as easy as just sorting by the original Date column!
1 Reply
- Tob_PHelper V
No need to reply - was as easy as just sorting by the original Date column!