Forum Discussion
1up
6 years agoResolver I
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...
- 6 years ago
You need brackets
Text.Lower([#"CustomerName"])
HotChilli
6 years agoCommunity Champion
You need brackets
Text.Lower([#"CustomerName"])
1up
6 years agoResolver I
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?