Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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")
Solved! Go to Solution.
Please try this instead.
= [#"DestinationType"] & " | " & Text.Replace([#Destination Name], "Spend", "Facts")
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Please try this instead.
= [#"DestinationType"] & " | " & Text.Replace([#Destination Name], "Spend", "Facts")
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.