Forum Discussion
Sort by the value that contains date
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
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
Thanks for the details and appologize for the late update. But this solution worked for me just now. Thanks again!
