Forum Discussion
Solved
Power Query - Token Comma Expected
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.
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))
2 Replies
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))Thank you
