Forum Discussion

alejandroezp's avatar
alejandroezp
Icon for Helper I rankHelper I
1 year ago
Solved

Using negation condition in switch function

Good morning,   I am trying to use a negative condition in a switch function. My idea is to assign a label to all the rows where appears a string. I am using something like this example: NOT(CONT...
Need Help
Tips and Tricks
Tutorial Requests
  • MasonMA's avatar
    MasonMA
    1 year ago

    Hi alejandroezp 

     

    You can try CONTAINSSTRING( ) that returns TRUE/FALSE directly in your SWITCH function. 

    SWITCH(
    TRUE(),
    CONTAINSSTRING('Facturas'[Comentario], "gratis"), "Free",
    CONTAINSSTRING('Facturas'[Comentario], "oferta"), "Discount",
    -- Add more as needed
    TRUE, "Other"
)

     

MasonMA's avatar
MasonMA
Icon for Super User rankSuper User
1 year ago

Hi alejandroezp 

 

You can try CONTAINSSTRING( ) that returns TRUE/FALSE directly in your SWITCH function. 

SWITCH(
    TRUE(),
    CONTAINSSTRING('Facturas'[Comentario], "gratis"), "Free",
    CONTAINSSTRING('Facturas'[Comentario], "oferta"), "Discount",
    -- Add more as needed
    TRUE, "Other"
)