Forum Discussion

BAFreedom's avatar
BAFreedom
Icon for Helper I rankHelper I
3 years ago
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...
Need Help
  • Migasuke's avatar
    Migasuke
    3 years ago

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

     

Migasuke's avatar
Migasuke
Icon for Memorable Member rankMemorable Member
3 years ago

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's avatar
BAFreedom
Icon for Helper I rankHelper I
3 years ago

Thank you