Creating a week offset that resets every year

Hi William_Walk 

I hope I understood correctly, 

If you want to define date periods with a text or a number column. You can define the date period in Power Query. For example. You want to have a two week periods. 

Add a custom column and add something like this. 

if Date.DayOfYear([Date]) <= 14 then "Period1" else 
if Date.DayOfYear([Date]) > 14 and Date.DayOfYear([Date]) <= 28 then "Period2" else "Period3"

Something along those lines. Using Date.DayOfYear will define this code for every year in your date table

Thanks

Joe

If this post helps, then please Accept it as the solution