"starts with" in an expression using DAX

Question

how can write an expression with DAX to check if a String starts by an other string ? example : ext.example starts with "ext."

Solution

This expression does the work,

NewColumn =
IF (
    LEFT ( TableName[ColumnToSearchIn], LEN ( "Some string" ) ) = "Some string",
    "Starts With",
    "Does not start with"
)

This expression will determine if ColumnToSearchIn starts with Some string.

Let me know if this helps.

Comments

[Khalil Liraqui]

yes but i want exactly starts with not find anywhere

[brentlightsey]

"Some string" could also be stored in variable if the search text is long, or needs to be determined by a formula: NewColumn = VAR search = "Some string" RETURN IF ( LEFT ( TableName[ColumnToSearchIn], LEN ( search ) ) = search, "Starts With", "Does not start with" )