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.
Go to Solution.
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!
View solution in original post
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!