Fiscal week not on the first day of month
Hi all, I'm trying to add Fiscal Week and Month to my date table. It starts on October. I used blog post by ChandeepChhabra which I found on a solved question on this website, to generate the Fiscal Week column and it worked but not my desired result. Question Link - https://community.powerbi.com/t5/Desktop/Creating-a-fiscal-week-column/m-p/556549 Blog Post Link - https://www.goodly.co.in/calculate-fiscal-week-in-power-bi/ This was the result I get when I used it. My desired fiscal week is a little different, it is not on the first day of the month. Here's an example: As you can see, the first week starts on the 3rd of Oct where as the result I got from refering to the post starts on 1st of Oct. If the first 2 days of the month is at the end of the week then it is considered to be the week of previous month. I would also like to add another column for the Month based on the fiscal week. Below is my desired Dim Date table. Date Work Week Month (WW) 10/1/2021 12:00:00 AM WW 52 September 10/2/2021 12:00:00 AM WW 52 September 10/3/2021 12:00:00 AM WW 1 October 10/4/2021 12:00:00 AM WW 1 October
