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,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

 

Thak you.

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

    Good morning,

     

    Sorry for delay, i was testing the solutions. At the end, the solution added by MasonMA worked and it has solved my problem.

     

    Thank you for the support

    Cheers