How to use Text.PositionOf in Power BI

How to use Text.PositionOf in Power BI

In this article you will learn what Text.PositionOf is, learn its syntax, and how to use it. Text.PositionOf is a Power Query function that returns the position of the specified occurrence of the text value substring found in text. An optional parameter occurrence may be used to specify which occurrence position to return (first occurrence by default). Returns -1 if substring was…