Make Month Week order by Month

[gilmore_staci]

Here my field, in the visual its ordered alphabetically.  When I try to relate this field to the Date in my caleder table, I get errors.  Is there a way to get this to order by Month?

Month Week = FORMAT('case'[Date Opened], "MMM") & " WK - " & 1 + WEEKNUM ( 'case'[Date Opened] )-WEEKNUM( STARTOFMONTH ('case'[Date Opened]))

[lbendlin · Accepted solution]

Use "sort a column by another column"

Remember that weeks and months are incompatible.