Forum Discussion

MKPartner's avatar
MKPartner
Helper II
7 months ago
Solved

Tweaking Financial Calendar

Good morning All,    Our company has change financial calendar. This means that January is starting since 5th of January (calendar week 02) and month closed is in 30th of January (calendar week 05)...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    6 months ago

    Hi MKPartner 

    I have attached a sample PBIX that uses a financial calendar along with the DAX logic.

    Hope this helps !!
    Thank You.



     

MKPartner's avatar
MKPartner
Helper II
6 months ago

This is my current data: 

Year NoDay of the yearQtrWeek of MonthMonth noMonth no PWeekWeek WKYearWC_MonthWC_DateMonth Index (related)Week_ValueDay of Week
83584512P1252WK522025grudzień 20252025P12WK52211
83594512P1252WK522025grudzień 20252025P12WK52202
83604512P1252WK522025grudzień 20252025P12WK52203
83614512P1252WK522025grudzień 20252025P12WK52204
83624512P1252WK522025grudzień 20252025P12WK52205
83634512P1252WK522025grudzień 20252025P12WK52206
83644512P1252WK522025grudzień 20252025P12WK52207
91111P011WK012026styczeń 20262026P01WK01111
92111P011WK012026styczeń 20262026P01WK01102
93111P011WK012026styczeń 20262026P01WK01103
94111P011WK012026styczeń 20262026P01WK01104
95111P011WK012026styczeń 20262026P01WK01105
96111P011WK012026styczeń 20262026P01WK01106
97111P011WK012026styczeń 20262026P01WK01107
98121P012WK022026styczeń 20262026P01WK02111

 

I would like to include Week 01 which is currently in 2026 into 2025. 

 

DateYear NoDay of the yearQtrWeek of MonthMonth noMonth no PWeekWeek WKYearWC_MonthMonth Index (related)Week_ValueDay of Week
21/12/202583584512P1252WK522025December 20255211
22/12/202583594512P1252WK522025December 2025202
23/12/202583604512P1252WK522025December 2025203
24/12/202583614512P1252WK522025December 2025204
25/12/202583624512P1252WK522025December 2025205
26/12/202583634512P1252WK522025December 2025206
27/12/202583644512P1252WK522025December 2025207
28/12/202591111P011WK012025December 2025111
29/12/202592111P011WK012025December 2025102
30/12/202593111P011WK012025December 2025103
31/12/202594111P011WK012025December 2025104
01/01/202695111P011WK012025December 2025105
02/01/202696111P011WK012025December 2025106
03/01/202697111P011WK012025December 2025107
04/01/202698121P012WK022026January 2026111

 

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    6 months ago

    MKPartner 

    since you only provide  a part of your data. I am not sure how to do this for the other years.

    just based on the sample data you provided.

    you can try to create columns

     

    Column =
    var _date=minx(FILTER('Table','Table'[Date]>=EARLIER('Table'[Date])&&'Table'[Day of the year]=7),'Table'[Date])
    return if('Table'[Day of the year]<=7,year(_date)-1,year('Table'[Date]))
     
    Column 2 = if('Table'[Day of the year]<=7 ,"December " & 'Table'[Column],FORMAT('Table'[Date],"mmmm")&" " & year('Table'[Date]))
     
     
    pls see the attachment below
    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      6 months ago

      Hi MKPartner 

      Following up to confirm if the earlier responses addressed your query byryan_mayu .If anything is still unclear, we’ll be happy to provide additional support.

    • MKPartner's avatar
      MKPartner
      Helper II
      6 months ago

      Thank you for your help. We are pretty OK. This means that 2026 year is OK as I expected, but previous year which where OK, no are NOK. Some weeks are overlapping for two months. 

      Screen for Feb 2026: 

       

      Screen for Feb 2025 -> week 9 in 2025 was in March 2025

       
       

      Screen for March 2025 -> week 14 in 2025 was in April 2025



      Actual calendar and expected in excel.

       

      Actual and Expected calendars 

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        6 months ago

        MKPartner 

        you highlighted two columns. I can find out the difference, however, can't understand the logic.

        i created one column for you, pls see the attachment below.