Let Text.PositionOfAny accept a list of strings than characters

[sundayDriver]

Text.PositionOf accepts a string, but not PositionOfAny: https://docs.microsoft.com/en-us/powerquery-m/text-positionofany

vs

https://docs.microsoft.com/en-us/powerquery-m/text-positionof

[v-zhenbw-msft]

Hi @sundayDriver ,

Do you want to find the position of one column in the other? Like the following screenshot.

Maybe you can use the Text.PositionOf to get the position, or you can use DAX function, like SEARCH, FIND.

If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data?

It will be helpful if you can show us the exact expected result based on the tables.

Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

Best regards,

Community Support Team _ zhenbw

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

[sundayDriver]

Hi @v-zhenbw-msft ,

Here's an example of what I meant:

Sentence = "Today is great and the weather is warm. Yesterday was good but tomorrow will be better."

Ideally it would be Text.PositionOfAny(Sentence, {"tod", "tomor", "yester"})

[fafhrd]

I second this request. It is inconsisent for Text.PositionOf to allow strings but for Text.PositionOfAny to only accept characters.

[MFelix]

Hi @sundayDriver ,

What is the question in this post? Can you elaborate a little more?

[sundayDriver]

Hi @MFelix 

I think I cannot find a clickable URL other than power BI portugal? Am I missing something?

See the example that I posted as an answer to @v-zhenbw-msft comment.

[MFelix]

Hi @sundayDriver ,

Check the blog post below can give you a good alternative.

http://www.girlswithpowertools.com/2018/06/search-text-using-list-of-keywords/

I have made a pbi using this techique check if this is what you need.

[v-zhenbw-msft]

Hi @sundayDriver ,

Do you want to get the position of each word in this sentence?

We suggest you to create three custom columns to show the result.

Best regards,

Community Support Team _ zhenbw

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

BTW, pbix as attached.

[MFelix]

Hi @sundayDriver ,

I did not post any URL, the link you get is from my signature. I will check the example and get back to you.