Fiscal Week Num and Fiscl Month based on Start and End Date per Year

[joshua1990]

Hello everybody!

I have the following table:

Fiscal Year Start Date	Fiscal Year End Date	Year
30.12.2019	03.01.2020	2020
04.01.2020	04.01.2021	2021
05.01.2021	03.01.2022	2022

This table shows me the start and end date per fiscal year.

Now I would like to include the Fiscal Week and Fiscal Month based on these information into my calendar table that consists for now the column [Date].

How would you do that?

[Greg_Deckler]

For Fiscal Year, 

Column in Date Table = MAXX(FILTER('Table','Date'[Date] >= 'Table'[Fiscal Year Start Date] && 'Date'[Date] <= 'Table'[Fiscal Year End Date]),'Table'[Year])

[joshua1990]

Thanks for your reply!

I can't add a new function/ column in my calendar table with MAXX(FILTER...

I can't select my calendar table as filter....