How to find a position of the text in a column that starts with a certain value

[qzqzjcjp]

I would like to find out the position of the row that starts with or contain "DE" from the column or list below. The result should be 1. What function shall I use?  Appreciate it first!

Column1

ABC

DEFQF

ESSS

DDDA

[ronrsnfld · Accepted solution]

= List.PositionOf(List.Transform(#"Previous Step"[Column1], each Text.StartsWith(_, "DE")),true)

or, possibly, depending on your real data and requirements:

= List.PositionOf(List.Transform(#"Previous Step"[Column1], each Text.StartsWith(_, "DE")),true,Occurrence.All)

[qzqzjcjp]

Amazing! Thank you ronrsnfld!