Forum Discussion
Solved
Make Month Week order by Month
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]))
Use "sort a column by another column"
Remember that weeks and months are incompatible.
1 Reply
Use "sort a column by another column"
Remember that weeks and months are incompatible.