Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
12-29-2020 00:52 AM
Power BI November to October Financial Year Calendar
Date = CALENDAR(date(2014,11,01),Date(2021,10,31))
Start Of Year = STARTOFYEAR('Date'[Date],"10/31")
End of Year = ENDOFYEAR('Date'[Date],"10/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]
Qtr Year Sort = year('Date'[Start Of Year])&'Date'[Qtr No]
Month Year = FORMAT('Date'[Date],"MMMM YYYY")
Month Year 2 = FORMAT('Date'[Date],"MMM-YYYY")
Month Year Sort = var _m = DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH)+1 return if(_m<10 , [Fin Year] &"0"&_m,[Fin Year] &_m)
Cal Year = YEAR('Date'[Date])
Fin Year = year('Date'[Start Of Year])
Month = FORMAT('Date'[Date],"MMMM")
Month Sort = DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH)+1
Qtr Start Date = DATEADD(STARTOFYEAR('Date'[Date],"10/31"),QUOTIENT(DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH),3)*3,MONTH)
Qtr Rank = rankx(ALL('Date'),'Date'[Qtr Start Date],,ASC,Dense)
eyJrIjoiZjM5NDU5NjAtZDRhNy00MTYxLTg0ZGYtMmQ4MzliMWE5NzkzIiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9