Forum Discussion

mpoche's avatar
mpoche
Frequent Visitor
3 years ago
Solved

Weird Fiscal Months

Hello,

 

I am trying to determine the best route to take to enter fiscal calendars into one date table, with a regular calendar option as well.

 

The fiscal year is October - September; however, the days and weeks can be different each year. Here are some samples from 2019 - 2022:

 

Fiscal MonthFiscal Month StartFiscal Month EndNumber of Days
10/01/2019..10/25/201910/1/201910/25/201924
10/26/2019..11/22/201910/26/201911/22/201927
11/23/2019..12/20/201911/23/201912/20/201927
12/21/2019..01/24/202012/21/20191/24/202034
01/25/2020..02/21/20201/25/20202/21/202027
02/22/2020..03/20/20202/22/20203/20/202027
03/21/2020..04/24/20203/21/20204/24/202034
04/25/2020..05/22/20204/25/20205/22/202027
05/23/2020..06/19/20205/23/20206/19/202027
06/19/2020..07/24/20206/19/20207/24/202035
07/25/2020..08/21/20207/25/20208/21/202027
08/22/2020..09/30/20208/22/20209/30/202039
10/01/2020..10/31/202010/1/202010/31/202030
11/1/2020..11/27/202011/1/202011/27/202026
11/28/2020..12/31/202011/28/202012/31/202033
1/1/2021..01/29/20211/1/20211/29/202128
01/30/2021..02/26/20211/30/20212/26/202127
02/27/2021..03/31/20212/27/20213/31/202132
04/1/2021..04/30/20214/1/20214/30/202129
05/1/2021..05/28/20215/1/20215/28/202127
05/29/2021..06/30/20215/29/20216/30/202132
07/1/2021..07/30/20217/1/20217/30/202129
07/31/2021..08/27/20217/31/20218/27/202127
08/28/2021..09/30/20218/28/20219/30/202133
10/1/2021..10/29/202110/1/202110/29/202128
10/30/2021..11/26/202110/30/202111/26/202127
11/27/2021..12/31/202111/27/202112/31/202134
1/1/2022..1/28/20221/1/20221/28/202227
1/29/2022..2/25/20221/29/20222/25/202227
2/26/2022..3/31/20222/26/20223/31/202233
04/1/2022..04/29/20224/1/20224/29/202228
4/30/2022..5/27/20224/30/20225/27/202227
5/28/2022..6/30/20225/28/20226/30/202233
7/1/2022..7/29/20227/1/20227/29/202228
7/30/2022..8/26/20227/30/20228/26/202227
8/27/2022..9/30/20228/27/20229/30/202234

 

Any help is appreciated.

 

Thanks

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    mpoche 

    you can create a column

    Column = maxx(FILTER('Table','Table 2'[Date]>='Table'[Fiscal Month Start]&&'Table 2'[Date]<='Table'[Fiscal Month End]),'Table'[Fiscal Month])

    pls see the attachment below

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    3 years ago

    mpoche 

    you can create a column

    Column = maxx(FILTER('Table','Table 2'[Date]>='Table'[Fiscal Month Start]&&'Table 2'[Date]<='Table'[Fiscal Month End]),'Table'[Fiscal Month])

    pls see the attachment below