Forum Discussion

matts29's avatar
matts29
Frequent Visitor
1 year ago
Solved

DAX help containstring

Hi, someone please help with my dax below?   currently I have the below: CurrentIn= if(AND(ED_Performance[DepartureDttm]=blank(), CONTAINSSTRING(ED_Performance[CurrentLocation],"theatre")),1,0) ...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    1 year ago

    OR only get two conditions

    or(con1,or(con2,con3))

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi matts29 ,
    As wdx223_Daniel mentioned, you can try the following code.

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

     

    Best regards,
    Albert He

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi matts29 ,
As wdx223_Daniel mentioned, you can try the following code.

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

 

Best regards,
Albert He

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