Power Query Dynamic Fiscal Year Header

[legalhustler]

Hi,

I'm trying to make the column header part of this step of my query dynamic (see below).

Where it shows "#"Fiscal Year" & " Amount" I want to subtract 3 from the formula so the year shows "FY 2018 Amount" instead of "FY 2021 Amount". The ""#"Fiscal Year" is a reference to another query that has the fiscal year like "FY 2021". How can I amend this step so it dynamically changes the fiscal year minus 3 years?

= Table.RenameColumns(Append,{{"Total Amount", #"Fiscal Year" & " Amount"}})

 

[legalhustler]

Anyone? I think I just need to wrap some other functions around to extract the four digit year then convert the text to a number and finally subtract 3?