topic Re: How to sort start of week column in my date table? in DAX Commands and Tips

How to sort start of week column in my date table?

ironboy0418 — Fri, 14 Apr 2023 01:59:19 GMT

I am trying to sort start of week column using the week rank calculated column I've created. However, I am encountering this error:

Start of week dax:

Week Rank dax:

FreemanZ — Fri, 14 Apr 2023 02:17:06 GMT

what do you mean by "sort start of week"?

ironboy0418 — Fri, 14 Apr 2023 02:28:01 GMT

Sorry. I am actually using it in my line chart, so that it will be sorted by start of week:

Everytime I use sort by column, it gives me the above error:

FreemanZ — Fri, 14 Apr 2023 02:46:26 GMT

seems no need for the rank column, try to rewrite your column like:

Start of Week =

[Date]-WEEKDAY([Date])

Then you shall be able to sort by the column itself. Or?

ironboy0418 — Fri, 14 Apr 2023 06:52:44 GMT

Thank you FreemanZ the start of week column is actually a text data type that's why I am encountering the error. Appreciate the help!

FreemanZ — Fri, 14 Apr 2023 06:59:13 GMT

Indeed, texts sort alphabetically. Number and Date are sorted numerically.