Forum Discussion

PowerBI123456's avatar
PowerBI123456
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

DAX Starts with

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!
Need Help
Tips and Tricks
  • MFelix's avatar
    MFelix
    5 years ago

    Hi PowerBI123456 ,

     

    Try the following:

    LEFT(Table[Column]), 3) = "992"
MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi PowerBI123456 ,

 

Try the following:

LEFT(Table[Column]), 3) = "992"
uzzysan's avatar
uzzysan
Regular Visitor
4 years ago

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

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      uzzysan
      Regular Visitor
      4 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

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