Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Token Comma Expected

hello,   I'm new to coding in Power Query. I tried adding the last line #"Padded Values" to the existing code but I am getting the Token Comma expected error.   Can someone please explain why? ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    All steps except the last need a comma after them.  Add a comma at the end of your #"Renamed Columns" step.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Your last step is referencing itself (so that variable doesn't exist yet).  Change it to reference your previous step.

 #"Padded Values" = Text.PadStart(#"Renamed Columns",[Level Prefix],5,"0")