Custom Column in Query Editor throwing "We Cannot apply field access to the type Function"

[1up]

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 Dealer - Country Description"

It would be nice to get a suggestion solution, and if possible a short explanation why the error happens. Have read another thread and creating a variable seemed to resolve the error.

My formula is looking for two specific customer names, and replaces them with other names, and for all other rows, the column value is to be adjusted into all-lower case.

if[#"CustomerName"] = "Charles" then "Charles Germany"
else if[#"CustomerName"] = "Nick" then "Nick UK"
else
Text.Lower[#"CustomerName"]

Thanks,

[HotChilli · Accepted solution]

You need brackets

Text.Lower([#"CustomerName"])

[JGrant8708]

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]

[1up]

So it was that simple after all, thanks a lot, all of a sudden this day seems much better. 🙂

Any one knows why paranthesis are needed for the text.lower-statement, while it is not needed for the if-statement?