Issue in month months dynamically

Hi lbendlin 

Sorry. Please refer the below sample data for your clarification.

This is my smaple output. my table report currently looks like this. 
Logic involved here. If Period = Quarter, rental Income /4 , This value will be applicable to the current + 11 months.

If period = month, rental Income /12 , This value will be applicable to the current + 11 months.

Now my new logic is going to be like below table,

I need to fetch current month + remaining months of the current year + next year all the months. 

These months name must be with the Current year in the headers. for example, Sep FY24.

Points to be noted. I  don't have a date field in my table, so to fetch the months i used this below m query.

currentMonth = List.Generate(()=>Date.Month(Date.From(DateTime.FixedLocalNow()))-1, each _ < Date.Month(Date.From(DateTime.FixedLocalNow()))+11, each _+1, each Date.MonthName(#date(1899,Number.Mod(_, 12)+1,1))))

Can I write a condition in this query like below?

If current month = september then 

currentMonth = List.Generate(()=>Date.Month(Date.From(DateTime.FixedLocalNow()))-1, each _ < Date.Month(Date.From(DateTime.FixedLocalNow()))+15, each _+1, each Date.MonthName(#date(1899,Number.Mod(_, 12)+1,1))))

If current month = October then

currentMonth = List.Generate(()=>Date.Month(Date.From(DateTime.FixedLocalNow()))-1, each _ < Date.Month(Date.From(DateTime.FixedLocalNow()))+14, each _+1, each Date.MonthName(#date(1899,Number.Mod(_, 12)+1,1))))

I tried to do this, But I get error in the If condition saying Current month name wasn't recognized.

Could you help me with your ideas on this?

Thanks in advance.