Forum Discussion
1up
Resolver I
Resolver ICustom Column in Query Editor throwing "We Cannot apply field access to the type Function"
In trying to add a custom column in the query editor, an error is displayed. "Expression.Error: We cannot apply field access to the type Function. Details: Value=[Function] Key=Repairing Deale...
You need brackets
Text.Lower([#"CustomerName"])
HotChilli
Community Champion
Community ChampionYou need brackets
Text.Lower([#"CustomerName"])
I had the same error message when I forgot an "&" between two text fields I was appending.
E.g., [Company] & " (" [Address]
Which needs to be [Company] & " " & [Address]