UK Fiscal Year Column

[moomarine]

Hi, I am trying to create a Date format Table which has a column for UK fiscal year based on another column date. I have managed to do from 01 April - 31 March using month calcs but need the fiscal year dates to be 06 Apr - 05 Apr in acordance with UK fiscal year.

The formula i have at the moment is as follows:

Fiscal Year = IF(MONTH(Date_Reference_Table[Date])>3,YEAR(Date_Reference_Table[Date])&"-"&YEAR(Date_Reference_Table[Date])+1,YEAR(Date_Reference_Table[Date])-1&"-"&YEAR(Date_Reference_Table[Date]))

[amitchandak]

@moomarine , look at Feb calendar in blog, that was a more custom build

https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...

Can help to create the one you want