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
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()