Forum Discussion

OsmanEmi's avatar
OsmanEmi
Frequent Visitor
5 years ago
Solved

M language Token EOF Expected

Hi,

When trying to add a column in power query I'm met with the error
"Token EOF Expected"

I wanted to ask if the syntax I'm using is incorrect

= ([#"DestinationType"] & " | " & [#Destination Name]
text.replace([#Destination Name], "Spend", "Facts")

Need Help
Show and Tell
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Please try this instead.

     

    = [#"DestinationType"] & " | " & Text.Replace([#Destination Name], "Spend", "Facts")

     

    Pat

1 Reply

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    Please try this instead.

     

    = [#"DestinationType"] & " | " & Text.Replace([#Destination Name], "Spend", "Facts")

     

    Pat