Power Query - Token Comma Expected

[BAFreedom]

In Power Query,

I am trying to use Power Query to general a Fiscal Year. 

Eg. If April 1, 2022, then Fiscal Year is FY22/23

Here is my Custom Column Formula:

if [Month] ❤️ then "FY" &
Text.End(Number.ToText([Year]),2) & "/" &
Text.End(Number.ToText([Year],2) else
"FY" &
Text.End(Number.ToText([Year]),2) & "/" &
Text.End(Number.ToText([Year}+1,2)

Result: Token Comma expected. When I click Show Error, it highlights "else."

How do I fix this?

Thanks.

[Migasuke · Accepted solution]

Hi @BAFreedom ,

I think you have few typos there. There is bracket missing + one bracket ) is }.
Check my code:

if [Month] ❤️ then "FY" &
Text.End(Number.ToText([Year]),2) & "/" &
Text.End(Number.ToText([Year],2)) else
"FY" &
Text.End(Number.ToText([Year]),2) & "/" &
Text.End(Number.ToText([Year]+1,2))

[BAFreedom]

Thank you