cancel
Showing results for
Did you mean: Anonymous
Not applicable

## Custom Calendar with 28 days and 4 weeks in a month

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.

1 ACCEPTED SOLUTION  Super User

@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``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition  DAX is easy, CALCULATE makes DAX hard...  Super User

@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``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition  DAX is easy, CALCULATE makes DAX hard...  