Text function in query editor returns error

[dmatliak]

Hi, when adding new column in query editor and trying just a simple function such as Text.Length it always returns error. I have a simple table:

Thanks for help.

[v-janeyg-msft · Accepted solution]

Hi, @dmatliak 

It’s my pleasure to answer for you.

According to your description,I think you missed '()' after the function of Text.Length.

Like this: Text.Length()

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@dmatliak , Can you click on error share the error

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s