Creating a date table with Broadcast Month and Year - Help with formulas

Hi! SQLBI has a date reference template table that should work well here. You can download it from their site and add it into your model as a date table. It works as a regular calendar, fiscal calendar, or fiscal weekly. You can choose what month is the first in the year, what day of the week a week starts, etc. I would imagine you should be able to get the fiscal weekly to work with your needs well. I use this all the time, and it is especially helpful when I am doing models that need to follow the NRF calendar. DAX Date Template - SQLBI

Here is a link that explains the table more. The above link is where you can download it from: Reference Date Table in DAX and Power BI - SQLBI