topic Re: Custom Column in Query Editor throwing "We Cannot apply field access to the type Function" in DAX Commands and Tips

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

1up — Wed, 11 Mar 2020 16:14:31 GMT

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,

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

HotChilli — Wed, 11 Mar 2020 17:44:59 GMT

You need brackets

Text.Lower([#"CustomerName"])

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

1up — Thu, 12 Mar 2020 07:39:43 GMT

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?

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

JGrant8708 — Fri, 10 Nov 2023 19:42:43 GMT

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]