DAX help containstring

matts29 ,

 

To handle multiple search strings in the same column, you can use the OR function in DAX to check for each condition. Here’s the updated formula that includes "theatre," "hall," and "attic" in your logic:

CurrentIn = 
IF(
    AND(
        ED_Performance[DepartureDttm] = BLANK(),
        OR(
            CONTAINSSTRING(ED_Performance[CurrentLocation], "theatre"),
            CONTAINSSTRING(ED_Performance[CurrentLocation], "hall"),
            CONTAINSSTRING(ED_Performance[CurrentLocation], "attic")
        )
    ),
    1,
    0
)

 

• The OR function is used to combine the multiple CONTAINSSTRING checks. If any of the strings ("theatre," "hall," or "attic") are found in the CurrentLocation column, the condition evaluates to TRUE.
• The AND function ensures that both DepartureDttm being blank and one of the strings being present are true for the result to be 1.
• If neither condition is met, the result is 0.

 

This way, you can search for multiple strings in the same column and maintain the desired logic. If you need to add more strings, simply include additional CONTAINSSTRING functions within the OR block.

 

Best regards,