31 March 2016

Adding Australian End of Financial Year in Power BI

Alright, it took me like forever to find, but once I've found it I decided to let the rest of the universe know.
If your financial year doesn't end on December 31st and you want to set it up on a different date, there is a way to cater for it in Power BI.
The DAX code for The Australian version, for a Fiscal year that ends on June 30th:
(According to https://msdn.microsoft.com/en-us/library/ee634245.aspx)

=ENDOFYEAR(DateTime[DateKey],"06/30/2004")
Having said that, I believe that if we're in Australia (or any other place which isn't US for that matter), maybe the code should be more in the lines of:

=ENDOFYEAR(DateTime[DateKey],"30/06/2004")