Calculate Fiscal Year

Calculates fiscal year starting the month of October

Fiscal Year = 
VAR fy_date = [Date] // replace with your date column here

RETURN
if(MONTH(fy_date) > 9, YEAR(fy_date)+1, YEAR(fy_date))