Forum Discussion

ryan_b_fiting's avatar
ryan_b_fiting
Post Patron
6 years ago
Solved

IF statement with text wildcard

Hey community -    I am looking to create a calculated column or measure based on finding a specific text within an entire text string column. Below is what I am trying to do (writing out/explaini...
Need Help
Show and Tell
Tips and Tricks
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi ryan_b_fiting ,

     

    You may create column like DAX below.

    PRIORITY GRADING =
VAR _Find =
    SEARCH ( "Final Project", Table1[Name], 1, -1 )
RETURN
    IF (
        _Find > 0,
        IF ( Table1[Days Since Submission] >= 3, "High", "Low" ),
        IF ( Table1[Days Since Submission] > 5, "High", "Low" )
    )

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
6 years ago

ryan_b_fiting ,  You can try Switch True

 

Change as per need

Switch (									
CONTAINSSTRING('Table'[NAME],"Final Project") &&		Table[Days Since Submission] >= 3 "High",
CONTAINSSTRING('Table'[NAME],"Final Project") &&		Table[Days Since Submission] < 3 "High",	
not(CONTAINSSTRING('Table'[NAME],"Final Project"))  &&		Table[Days Since Submission] > 5 "High",
"Low")