Forum Discussion
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...
Hi Lizzieleman ,
In the code you provided:
There are 13 "(" and only 12 ")". You need to add a ")" at the end of the code.
And remember to accept amitchandak 's answer as a solution.
Best Regards,
Dino Tao
I've figured out the brackets but now I get another error
"Token 'then' expected, could someone help me figure this out?
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))