UK Fiscal Year Column

Question

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 · Answer

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-Calendar-1-5-Power/ba-p/1187441
&nbsp;
Can help to create the one you want

Forum Discussion

UK Fiscal Year Column

1 Reply

Related content

Fiscal Year required

Fiscal Year Calculated Columns

Custom Column - Current Fiscal Year

Fiscal Year and Fiscal Quarter

Fiscal Year Filter