Set a season year for reports

[RossChevalier]

Hello,

I am starting to build two new reports.  The first is simple because it is based on calendar years so the filter creation is very easy.

I am at a loss as to how to do the second one as it needs filter on seasonal years.  In our business, our harvest year is from April 1st to March 31st of the following year.  Is there a tool that allows me to create a different type of "year" for reporting that is different from a calendar year?

Thank you

[parry2k · Accepted solution]

@RossChevalier yes it can be done, you need to use fiscal year in your model. here are some links to get your going

https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-2-fiscal-columns

https://blog.enterprisedna.co/learn-how-to-calculate-sales-financial-year-to-date/

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[RossChevalier]

Thanks for the links, they should get me going!

Kudos!