You could create an inline table that has new values for each calendar month. For example
LOAD * INLINE [
If you have a calendar table already, you can just join the inline table with it. You can then select months from your regular month and max(financialPeriod) will give you the result you want.