Forum Discussion

Lizzieleman's avatar
Lizzieleman
Frequent Visitor
2 years ago

Fiscal year in format 2023-24 for example

Hi there, I created a date table in power query and have created a fiscal year column, but it says 2023, rather than 2023-24, for example. Does anyone have M code I could try to get it in the correct...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Lizzieleman , Create a new column like

 

If( Date.Month([Date]) <=3 , Number.ToText(Date.Year([Date])) & "-" & Text.End(Number.ToText(Date.Year([Date])+1),2) ,  Number.ToText(Date.Year([Date])+1) & "-" & Text.End(Number.ToText(Date.Year([Date])+2),2)  )