Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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!
@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!
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |