Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
mpoche
Frequent Visitor

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

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
ryan_mayu
Super User
Super User

@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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.