Forum Discussion

1up's avatar
1up
Icon for Resolver I rankResolver I
6 years ago
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...
  • HotChilli's avatar
    HotChilli
    6 years ago

    You need brackets

    Text.Lower([#"CustomerName"])

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
6 years ago

You need brackets

Text.Lower([#"CustomerName"])

1up's avatar
1up
Icon for Resolver I rankResolver I
6 years ago

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?