Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Align Months to custom weeks

So I created custom weeks to start on a Saturday using a formula   = 'Calendar'[Date] - WEEKDAY([DATE]+1,1)+1 Now however months don't align to the custom weeks. For example, in January the 31st ...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous it is all about calendar dimension in your model, you can control how your week/months to be used. here is a link which can be helpful and you can make the changes accordingly to your calendar table in your model.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Apologies but I cannot see information on that page. There is a link to another page that alludes to 4-4-5 calendars but those are not demonstrated. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Has anyone got any ideas on this?

     

    Still looking for answers.

    • v-piga-msft's avatar
      v-piga-msft
      Icon for Resident Rockstar rankResident Rockstar
      7 years ago

      Hi Anonymous ,

       

      I'm afraid that parry2k want to direct you to this article.

       

      In additio, to understand your scenario better and get the solution quickly, could you share your data sample and your desired output so that we could help further on it?

       

      Best Regards,

      Cherry

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        My calendar data is just a standard calendar that you create in PowerPivot or PowerBI. I then added an extra column to reflect our weeks being Saturday to Friday.

         

        This is the formula I used.

        = 'Calendar'[Date]  - WEEKDAY([DATE]+1,1)+1

        I then wanted to add an extra column to adjust the month to end on the Friday. So a work months calendar.