Fiscal calendar

[shantupm5]

Hello,

I have an existing calender which start from Jan of every year, how can i convert  or adjust it to my fiscal calendar which starts from 1st of April every year.

Please advice

Regards

Prashanth

[DOLEARY85]

Hi,

there's a good post on how to do this here:

https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[shantupm5]

Hello,

I have a column with order book date which is in calender date (Start of the Year is Jan).

How can i convert this order book date to Fiscal Calendar?

[olgad]

How did you create your calendar table?

[shantupm5]

Hello,

Its jus a normal date entry. The data is imported thru excel sheet.