web
You’re offline. This is a read only version of the page.
close
Skip to main content

Power BI (Internal)

New

Support for custom fiscal years

Vote (10) Share
Joost ten Kattelaar's profile image

Joost ten Kattelaar on 09 Feb 2016 20:38:07

As we all know, our fiscal year does not start at the beginning of the calendar year. Would really help if we can change the start of a fiscal year in Power BI.

Comments (1)
Joost ten Kattelaar's profile image Profile Picture

David Butler (CSAM) on 05 Jul 2020 22:26:36

RE: Support for custom fiscal years

I agree, this would be great functionality to have built-in. In the meantime, I've been adding a calculated column to my date table called "FiscalMonth" using a SWITCH statement to assign the correct fiscal month number based on the calendar month number. Hope this helps.