Forum Discussion
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/explaining and not writing the DAX here):
PRIORITY GRADING = if NAME CONTAINS "Final Project" AND Days Since Submission >= 3 "High",
if NAME CONTAINS "Final Project" AND Days Since Submission ❤️ "Low",
if NAME DOES NOT CONTAIN "Final Project" AND Days Since Submission >5 "High" otherwise "Low"
My issue I am having is with the bolded part above. How do I search with 'wildcard' to see if the text column contains 'Final Project'.
As always your help is greatly appreciated
Thank You
Ryan
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.
3 Replies
PRIORITY GRADING =
SWITCH (
TRUE (),
SEARCH ( NAME, "Final Project", 0 ) > 0, SWITCH (TRUE (),
[Days Since Submission] >= 3, "High", "Low" ),
[Days Since Submission] > 5, "High", "Low"
)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")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.
