DAX Starts with

[PowerBI123456]

Hi - I want to see if a column starts with a specific line of strings (e.g. "992"). How can I do that in DAX (not power query)?

Thanks in advance!

[MFelix · Accepted solution]

Hi @PowerBI123456 ,

Try the following:

LEFT(Table[Column]), 3) = "992"

[uzzysan]

And what about cases where length of the string I'm looking for vary? For example {"site", "location"}

[MFelix]

What do you mean by having a different length?

This is for the beginning of the text so it does not matter the size of the text.

[uzzysan]

If I want to look for different words (example list in { }) which differ in length if text starts with those and depending on which does it start with, take different action

[tqluengo]

Then you can use MID() instead of LEFT()

[amitchandak]

@PowerBI123456 , Try a new column like

if(left([col1],3) = "992",1,0)

or measure

calculate(countrows(Table),filter(Table,left([col1],3) = "992",1,0))