Text.StartsWith

Text

Returns true if a text value starts with a specified substring.

Syntax

Text.StartsWith(text as nullable text, substring as text, optional comparer as nullable function) as nullable logical

Name	Type	Required	Description
`text`	`text`	Yes	The text value to check.
`substring`	`text`	Yes	The substring to match at the beginning.
`comparer`	`function`	No	A comparer function to control case sensitivity.

logical — true if the text starts with the substring, false otherwise.

Text.StartsWith checks whether a text value begins with a given substring. Like Text.Contains, the comparison is case-sensitive by default.

Table.SelectColumns(
    Table.SelectRows(OrderLog, each Text.StartsWith([Notes], "New order")),
    {"LogID", "Action", "Notes"}
)

Result

✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks