Forum Discussion
Get Current Fiscal year
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!
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!
1 Reply
_sfrostSolution Specialist
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!