Hello, Schools count their weeks from the beginning of terms. I’d like to add a week number to the basic date table that resets at the start of each term. I’m looking for something like this: [image] My term dates table looks like this: [image] Any help to get me started would be greatly appre…

Hi @dalef , So this is what I’ve got for you. Created a separate fxCreateTermTable function ( Semester as number, Term as number, StartDate as date, EndDate as date ) as table => let DayCount = Duration.Days( EndDate-StartDate )+1, DateList = List.Dates( StartDate, DayCount, Duration.From(…

School term week number

Power Query

Melissa September 29, 2021, 1:48pm 2

Hi @dalef,

Welcome to the Forum!

I’d be happy to look into that with you so could you supply the term dates table data and confirm are you referring to this basic date table?

Thanks!

1 Like