Forum Discussion
Solved
Custom 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"])
You need brackets
Text.Lower([#"CustomerName"])
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?
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]
