Australian financial year table

[Anonymous]

Hi all

Australian FY runs from 1st July to 30th June. 

I'm trying to build a date table in Power Query. Is there a way to change the format to show the financial year column as 2018 - 2019 as opposed to 2019 below? 

The same would apply for the quarters. At the moment Q1 starts from 1st January. For us, Q1 starts from 1 Jul to 30 Sept and so forth. 

At the same time, is it advisable to add this FY column using M via Power Query or thru DAX? 

[amitchandak · Accepted solution]

@Anonymous , Try like

if Date.Month([Date]) < 7 then Number.ToText(Date.Year([Date]) -1) & "-" & Number.ToText(Date.Year([Date])) else Number.ToText(Date.Year([Date]) ) & "-" & Number.ToText(Date.Year([Date]) + 1)