question

LinaQuintana-5241 avatar image
0 Votes"
LinaQuintana-5241 asked Lz-3068 commented

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-not-supported
5 |1600 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.

5 |1600 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 Lz-3068 commented

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

· 1
5 |1600 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 ·