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.

lbendlin's avatar
lbendlin
Super User
6 years ago

PRIORITY GRADING =
SWITCH (
    TRUE (),
    SEARCH ( NAME, "Final Project", 0 ) > 0, SWITCH ( 

                     TRUE (), 

                     [Days Since Submission] >= 3, "High", "Low" ),
    [Days Since Submission] > 5, "High", "Low"
)