Forum Discussion
Need Help Ordering by Academic Term
Hi everyone,
I am having trouble getting my data to order by academic term. Currently, everything wants to order by the first letter of the term (ex. Summer 2018). I need to have a custom order where Fall 2018 comes before Spring 2019, Summer 2019, and so on.
I've tried making a sort column and assigning a numeric value to each academic term, but get an error each time.
This is how I created the academic term for reference:
Any help is much appreciated. Please let me know if there is any other info I need to provide!
Try this solution.
Create a sort table with one row per Academic Term:
Create a relationship between the sort table and the calendar table:
In the calendar table, create a calculated column:
Academic Sort Column = RELATED ( AcademicTermSort[Academic Term Sort] )In the calendar table, sort Academic Term by Academic Sort Column.
1 Reply
Try this solution.
Create a sort table with one row per Academic Term:
Create a relationship between the sort table and the calendar table:
In the calendar table, create a calculated column:
Academic Sort Column = RELATED ( AcademicTermSort[Academic Term Sort] )In the calendar table, sort Academic Term by Academic Sort Column.