Last 6 Fiscal Month calculated column

[joshua1990]

Hello everybody!

I need some time intelligence in my calendar for my visuals to show the last 6 fiscal months.

The calendar has the following structure:

Date - Fiscal Month Number

Every fiscal month has a different start and end date compared to the normal month. Functions like EOMONTH are no working.

How can I get a calculated column with TRUE/ FALSE if the date is in the last 6 fiscal months?

[lbendlin]

show the structure of your Fiscal Month Number.  Ideally it also includes the year.

When you say "last six fiscal months"  do you include or exclude the current fiscal month?

[joshua1990]

Thanks for your reply!

The structure is like:

Date	Fiscal Week	Fiscal Month	Fiscal Year
31.12.2019	1	1	2020
01.01.2020	1	1	2020
31.01.2020	5	2	2020