Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
9 years ago

445 Calendar

HI Everyone,

i'm  still new in Power BI , and i'm having much problem with 445 calendar even i tried many tutorials on youtube in term of this.

can anyone help to create the month date to me based on the financial monthend below ? If possible to show me how to create it ? I'm stuck with this.
For example : Jan on 27 , Feb on 26 , Mar On 31 , Apr On 28 , May on 26 , June on 30 , Jul on 29 , Aug on 25 , Sep on 29 , OCt On 27 , Nov On 24 , Dec on 30 . 
Above are month end closing from my side.

 

Thanks with Best REgards,
Chanleakna Hang  

5 Replies

    • Chanleakna123's avatar
      Chanleakna123
      Post Prodigy
      9 years ago
      Hi , 
      Thanks for your attention here . Really appreciated. 
       
      In fact, my org. Used 445 calendar in order to in line with global financial calendar which easier to see monthly or weekly report in one calendar no matter which country u a. 
      While now I'm using general auto calendar which month end closing is always exceed my 445 calendar. That is why it's hard for me to visual the data correctly. 
       
      Can u please help on this?
       
      Thanks with best regards,
      Chanleakna Hang 
      • v-viig's avatar
        v-viig
        Community Champion
        9 years ago

        I don't happen to know any Power BI visual that supports 445 calendar unfortunately.

        You might try to play with these custom visuals, but don't think that they meet your requirements:

         

        Ignat Vilesov,

        Software Engineer

         

        Microsoft Power BI Custom Visuals

        [email protected]

  • dkangel21's avatar
    dkangel21
    Frequent Visitor
    5 years ago

    Rolled out my own 4-5-4 Calendar - it still uses a retail style front end - Partner insisted on this.  I created an algorithm years ago that recreates the 4-5-4 calendar via modulo arithmetic.  Haven't done it yet for a 4-4-5 calendar but I am sure it is doable.  Note the TimeFrame - it is QTD on a 4-5-4 calendar basis for Week Ending 5/1 (Currently selected week)