Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tgardner
Helper I
Helper I

Text.PositionOf() returning only '-1' in all cirumstances despite search term being present.

Self explanatory I think. 

 

 Col

"test"  

 

Text.PositionOf("test", [Col]) -- returns -1

Error occurs with individual letters and spaces and all values in the column and in different tables. I'm honestly baffled.

 

Hopefully a simple oversight, any help would be amazing!

 

Thanks

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @tgardner 

The arguments are the wrong way around.  It should be 

 

 

Text.PositionOf([Col], "test"))

 

 

If you have it like this

 

 

Text.PositionOf("test" , [Col]))

 

 

and there is anything before the word test in the Col column, it'll return -1

Phil


If I answered your question please mark my post as the solution.

If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

3 REPLIES 3
PhilipTreacy
Super User
Super User

Hi @tgardner 

The arguments are the wrong way around.  It should be 

 

 

Text.PositionOf([Col], "test"))

 

 

If you have it like this

 

 

Text.PositionOf("test" , [Col]))

 

 

and there is anything before the word test in the Col column, it'll return -1

Phil


If I answered your question please mark my post as the solution.

If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


What an embarassing oversight!

 

Thanks so much.

FrankAT
Community Champion
Community Champion

Hi @tgardner 

with your sample and description I get the following solution:

 

23-10-_2020_21-38-58.png

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.