Weird Fiscal Months

[mpoche]

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 Month	Fiscal Month Start	Fiscal Month End	Number of Days
10/01/2019..10/25/2019	10/1/2019	10/25/2019	24
10/26/2019..11/22/2019	10/26/2019	11/22/2019	27
11/23/2019..12/20/2019	11/23/2019	12/20/2019	27
12/21/2019..01/24/2020	12/21/2019	1/24/2020	34
01/25/2020..02/21/2020	1/25/2020	2/21/2020	27
02/22/2020..03/20/2020	2/22/2020	3/20/2020	27
03/21/2020..04/24/2020	3/21/2020	4/24/2020	34
04/25/2020..05/22/2020	4/25/2020	5/22/2020	27
05/23/2020..06/19/2020	5/23/2020	6/19/2020	27
06/19/2020..07/24/2020	6/19/2020	7/24/2020	35
07/25/2020..08/21/2020	7/25/2020	8/21/2020	27
08/22/2020..09/30/2020	8/22/2020	9/30/2020	39
10/01/2020..10/31/2020	10/1/2020	10/31/2020	30
11/1/2020..11/27/2020	11/1/2020	11/27/2020	26
11/28/2020..12/31/2020	11/28/2020	12/31/2020	33
1/1/2021..01/29/2021	1/1/2021	1/29/2021	28
01/30/2021..02/26/2021	1/30/2021	2/26/2021	27
02/27/2021..03/31/2021	2/27/2021	3/31/2021	32
04/1/2021..04/30/2021	4/1/2021	4/30/2021	29
05/1/2021..05/28/2021	5/1/2021	5/28/2021	27
05/29/2021..06/30/2021	5/29/2021	6/30/2021	32
07/1/2021..07/30/2021	7/1/2021	7/30/2021	29
07/31/2021..08/27/2021	7/31/2021	8/27/2021	27
08/28/2021..09/30/2021	8/28/2021	9/30/2021	33
10/1/2021..10/29/2021	10/1/2021	10/29/2021	28
10/30/2021..11/26/2021	10/30/2021	11/26/2021	27
11/27/2021..12/31/2021	11/27/2021	12/31/2021	34
1/1/2022..1/28/2022	1/1/2022	1/28/2022	27
1/29/2022..2/25/2022	1/29/2022	2/25/2022	27
2/26/2022..3/31/2022	2/26/2022	3/31/2022	33
04/1/2022..04/29/2022	4/1/2022	4/29/2022	28
4/30/2022..5/27/2022	4/30/2022	5/27/2022	27
5/28/2022..6/30/2022	5/28/2022	6/30/2022	33
7/1/2022..7/29/2022	7/1/2022	7/29/2022	28
7/30/2022..8/26/2022	7/30/2022	8/26/2022	27
8/27/2022..9/30/2022	8/27/2022	9/30/2022	34

Any help is appreciated.

Thanks

[ryan_mayu · Accepted solution]

@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