Forum Discussion
Solved
Sort by the value that contains date
Hello everyone, I wonder if anyone could please help me understand how to sort the data by "week of" so that it's in order of the date. This "week of" field is a column that concatenated string "...
Hi shiex1 ,
The first thing to make clear is that [week of] is a Text type field, and as HotChilli said, the sorting((alphabetically)) is correct. If you want that [week of] field to be sorted by the date in it, you might consider changing the format of the [week of] field to the format in Table2 in the figure below. This will give you the sorting results you expect...
If the field [week of] is a calculated column, you can update its formula as below:
week of = "Week of "&FORMAT('Table'[Date],"MM/DD/YYYY")Or you can select the field [week of] and navigate to Column tools ribbon to Sort by Column the field [Date]...
Best Regards
HotChilli
Community Champion
Community ChampionIt has sorted correctly (alphabetically), it's just not what you want.
You should be able to use 'Sort by Column' feature, using the original date as the other column