Forum Discussion
fiscal year calculation
Hello,
I have a date column which contain date starting from fiscal month Nov to Oct.
| Date |
| Nov-20 |
| Dec-20 |
| Jan-21 |
| Feb-21 |
| Mar-21 |
| Nov-21 |
| Dec-21 |
| Jan-22 |
| Feb-22 |
| Mar-22 |
I would like to create custom column year which shows fiscal year
so my desired output will be
| Date | Fiscal Year |
| Nov-20 | 2021 |
| Dec-20 | 2021 |
| Jan-21 | 2021 |
| Feb-21 | 2021 |
| Mar-21 | 2021 |
| Nov-21 | 2022 |
| Dec-21 | 2022 |
| Jan-22 | 2022 |
| Feb-22 | 2022 |
| Mar-22 | 2022 |
Anonymous , In this blog I create all 12 months calendar and given links
Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441Using year from start date of year and end date of year , you can get the above
new columns
endofyear =endofyear('Date'[Date],"10/31")
FY= Format([Date],"mmm-YYYY") & format([endofyear], "YY")
2 Replies
- amitchandak
Super User
Anonymous , In this blog I create all 12 months calendar and given links
Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441Using year from start date of year and end date of year , you can get the above
new columns
endofyear =endofyear('Date'[Date],"10/31")
FY= Format([Date],"mmm-YYYY") & format([endofyear], "YY")
Thanks amitchandak