Custom Calendar with 28 days and 4 weeks in a month

[Anonymous]

I have a requirement where i have a start and end date but here the month has to be 28 days and each month consists of 4 weeks.

Currently i have done this 

but the problem here is, i am not able to reset the month or the week column i.e my weeknum should be 1,2,3,4,1,2,3,4 instead of 1,2,3,4,5,6,7,8.. 

Same goes with the month(Row number column) after the year end it should reset and start from 1.

[Greg_Deckler · Accepted solution]

@Anonymous I created this calendar for you in the attached PBIX file below signature. Here are some of the columns:

Sequential = COUNTROWS(FILTER('284Calendar',[Date]<=EARLIER([Date])))

FY = 2020 + TRUNC([Sequential]/364)

Month = TRUNC(COUNTROWS(FILTER('284Calendar',[Date]<EARLIER([Date]) && [FY] = EARLIER([FY])))/28) + 1

Week = TRUNC(COUNTROWS(FILTER('284Calendar',[Date]<EARLIER([Date]) && [FY] = EARLIER([FY]) && [Month] = EARLIER([Month])))/7) + 1