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