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"
)

     

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi alejandroezp,

Have you had a chance to review the solution we shared by MasonMA Cookistador. If the issue persists, feel free to reply so we can help further.

 

Thank you.