Forum Discussion
Custom date table set via school semesters/terms/weeks
Hi all
Does anyone know how to add custom semester numbers/term numbers and week numbers to a date table?
I have no problem creating comprehensive date tables but I'm really struggling adding in custom terms and weeks etc.
In my normal date table, week numbers etc are no problem but I'm having an issue making them reoccur by term.
I've watched/read heaps of info on this but I can't seem to apply it to my model.
Anyone's help would be much appreciated.
Thank you
9 Replies
- parry2k
Super User
Anonymous what is the logic to create these column? Can you provide some details?
Hi parry2k
This particular example is to produce a transport related report.
I need to track passenger numbers, arrival/departure times, trip durations etc.
The only issue is schools tend to run via weeks in a term e.g. Term 2 - Week 3/Term 4 - Week 8 etc
So I need to be able to track the data across weeks in a term, Terms in a year and Semesters per year.
Example:
Term 1 = 29th Jan 2019 to 5th April 2019 (10 weeks)
Term 2 = 23rd April to 21st June 2019 (9 weeks) and so on and so forth
I could create a slicer to replicate the groupings using days/months but it's not polished enough for what I'm trying to achieve.
I have managed to create what I need for a single term using WEEKNUM +/- but trying to get that to repeat including terms which make the weeks start again from zero has me stumped.
Appreciate your help!
- parry2k
Anonymous can you put example in excel sheet and share it? You can share it via one drive/google drive or by email which is in my signature.
