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.
12-29-2020 21:35 PM
Power BI December to November Financial Year Calendar
Date = CALENDAR(date(2014,12,01),Date(2021,11,30))
Start Of Year = STARTOFYEAR('Date'[Date],"11/30")
End of Year = ENDOFYEAR('Date'[Date],"11/30")
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 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)
Qtr Year Sort = year('Date'[Start Of Year])&'Date'[Qtr No]
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],"11/30"),QUOTIENT(DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH),3)*3,MONTH)
Qtr Rank = rankx(ALL('Date'),'Date'[Qtr Start Date],,ASC,Dense)
eyJrIjoiNzRhYTIwNWQtNmJkOC00MWIwLWE4ZjAtN2EzMDQ2ZGZlODliIiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9