question

LinaQuintana-5241 avatar image
0 Votes"
LinaQuintana-5241 asked ·

Text.Middle Basic Formula Power Query

I´m trying to use the formula Text.Middle for a custom column, but get an error of expression.

Error
Expression error: the name Text.Middle is not recognized. Make sure it is spelled correctly.

I´ve checked the spelling and theres no issue. What am I doing wrong?

78328-error-text-middle-m.png


I´ve used other text formulas with no issue whatsoever. For example Text.PositionOf as shown:

78329-text-position-of.png


power-query-m
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Ehren avatar image
0 Votes"
Ehren answered ·

It's likely that you're using an older version of Power Query. Can you share your PQ version? If you installed it as an addin, please upgrade the addin to a more recent release. If it came as part of Excel, you will need to update Excel in order to get an updated version of PQ.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LinaQuintana-5241 avatar image
0 Votes"
LinaQuintana-5241 answered ·

I have Excel 2016 which came with PQ already. I wil try upgrading my excel. Thanks.

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@LinaQuintana-5241. If you dowload a copy of this workbook and Refresh the query, you'll get a list of the functions available to you. Hope this helps (a bit)


0 Votes 0 ·