topic Re: Fiscal Week Num and Fiscl Month based on Start and End Date per Year in DAX Commands and Tips

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

joshua1990 — Mon, 20 Apr 2020 14:01:53 GMT

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?

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

Greg_Deckler — Mon, 20 Apr 2020 14:07:48 GMT

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])

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

joshua1990 — Mon, 20 Apr 2020 14:33:40 GMT

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....