Forum Discussion
Sort Week End across Dec 31/Jan 1 in Matrix
I'm trying to create a matrix with the following structure: Rows: Business Unit Columns: End of Week (Mon-Sun) Values: % Tasks Completed Filter: Last 12 Weeks (relative) Because the last 12 w...
aflintdepm , Sorry, Seem like my mistake try with date a new column
Week Year = "W" & weeknum(Calendar[Date], 2) & "-" & year(Calendar[Date])
amitchandak Thank you for your continued help. Your formula worked as expected, however, it did not result in the correct sorting order in the matrix.
Also, I can't use this column to sort my "End of Week" column because I get this error:
Any idea what I'm doing incorrectly?