Calendar Year to Fiscal Year Conversion.

[Anonymous]

Hi,

I've to Convert my Date Collumn from Calendar Year to Fiscal Year based on our Organization where Fiscal Year starts from Oct2020 to Sep2021.  After conversion I need to link Master Calendar.

Need help on this, I've attached my .pbix file for you reference.https://drive.google.com/file/d/1kd3Vhyw8hY6Ag3pEDkuJHcdWZkeYtPTg/view?usp=sharing 

[amitchandak · Accepted solution]

@Anonymous ,do you need a calendar? I have given all 12 months calendar in the blog below. Also, Oct to sep file is attached after signature

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/1187441

[Anonymous]

Thanks a lot. You saved my day.