Custom Fiscal Year, Month and Quater from Measure or Date Table

[GideonTA]

I would like to create a Custom Fiscal Year, Month and Quater for company Fiscal Year that ran from 1 March to 28/29 Feb. 
Thanks.

[v-yalanwu-msft · Accepted solution]

Hi, @GideonTA ;

If you want to show the year\quater\month of Fiscal year . you could create measures as follows:

FY year = "FY"&YEAR(EOMONTH(MAX([Date]),-2))

FY-Quater = "FY-Q"&QUARTER(EOMONTH(MAX([Date]),-2))

FY-Quater = "FY-Q"&QUARTER(EOMONTH(MAX([Date]),-2))

The final output is shown below:

https://www.youtube.com/watch?v=1-agbCF7HwY

If you have other needs for the financial year, you can create a scenario to illustrate the specific needs.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@GideonTA Depends on the specific format of your custom fiscal year, but here is a flexible DAX formula for a 445 custom fiscal calendar that I created:

DAX Custom 445 Calendar - Microsoft Power BI Community