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

I have bit understood my needs in this case. 

 

Week number are OK. Our financial calendar was change for 2026 and January is since week 2 to week 5. 

 

Could you please help to tweak above code to include week 01 into 2025 year ? I have tried to read susgested links but I'm doing something wrong. 

 

 

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