Creating a week offset that resets every year

[William_Walk]

Hi

Im in the middle of creating a calendar table for a new report and am seeking a way of reporting in variable periods for each year. Is it possible that for the 1st january the period starts and for the 31st December it ends. It would be useful for me for every x number of weeks = 1 period allowing me to change reporting periods as I please. 

Thanks

[JoeBarry]

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

[nirali_arora]

You can go through the following blog for creating a week offset that resets every year-

https://community.powerbi.com/t5/Community-Blog/Week-That-Resets-Yearly-Decoding-Date-and-Calendar-3...