Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
September to August Financial Year Calendar
Date = CALENDAR(date(2014,09,01),Date(2021,08,31))
Start Of Year = STARTOFYEAR('Date'[Date],"8/31")
End of Year = ENDOFYEAR('Date'[Date],"8/31")
Qtr No = QUOTIENT(DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH),3)+1
FY = "FY "&FORMAT('Date'[Start Of Year],"YYYY") & "-" &FORMAT('Date'[End of Year],"YYYY")
Qtr Year = "Q" & 'Date'[Qtr No] & " "& 'Date'[FY]
Month Year = FORMAT('Date'[Date],"MMMM YYYY")
Month Sort = DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH)+1
Qtr Start Date = DATEADD(STARTOFYEAR('Date'[Date],"8/31"),QUOTIENT(DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH),3)*3,MONTH)
eyJrIjoiZWFhMWIzYzEtODA5MS00MWY4LThhMjktYmZlODAxMDFmZGFhIiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9