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
Lizzieleman's avatar
Lizzieleman
Frequent Visitor
2 years ago

I get an error

 

"Expression.Error: The name 'If' wasnt recognised. Make sure it is spelled correctly.

I changed it to

 

= Table.AddColumn(#"Changed Type", "Custom", each 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)

and now it says Expression.SyntaxError: Token ')' expected.

But I can't figure out where that ) would go

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • Lizzieleman's avatar
    Lizzieleman
    Frequent Visitor
    2 years ago

    Yes I tried this it still has the same error

     

    Code now reads like this:

    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)))

     

    But doesn't work

  • Lizzieleman's avatar
    Lizzieleman
    Frequent Visitor
    2 years ago

    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))