Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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.
Proud to be a 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.
Proud to be a Super User!
What an embarassing oversight!
Thanks so much.
Hi @tgardner
with your sample and description I get the following solution:
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |