Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Australian financial year table

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? 

 

 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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)

     

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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)