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.



     

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.