Get Current Fiscal year

[Anonymous]

My fiscal year starts from July to June. How do I get the current fiscal year?

My data has a calendar year until FY 2025. and currently we are in FY 2021. 

using today() functions breaks when calendar year ends in december. 

any help!

[_sfrost · Accepted solution]

@Anonymous 

You can create fiscal columns in your calendar table as explained in the below blog post and leverage those columns in your calculations.

Create a Date Dimension in Power BI in 4 Steps – Step 2: Fiscal Columns - RADACAD

To handle this with DAX, refer to the following post

Creating Financial Calendar - Decoding Date and Ca... - Microsoft Power BI Community

Did I answer your questions? Give a thumbs up and accept this post as solution!