Forum Discussion

franzotti's avatar
franzotti
Regular Visitor
3 years ago
Solved

Search using the CONTAINSSTRING with " (quotes) in text.

I need identify the sizes for the monitor. How do i search using the CONTAINSSTRING for " (quotes) no Power BI ? SWITCH(TRUE(), (CONTAINSSTRING(Dim_CA_NumeroSerie[Modelo], " 22" " )), " 22" " ) M...
  • Waldo35's avatar
    3 years ago

    Sorry but do you only need the one who are a specific set of digits or am i misunderstanding, my english isn't native. My script returns all the sizes, no matter the characters.

    Extreem sample:

     

    edit:

    if u want to check for a specific condition on the result you can do a check on the new column with either if or switch. for instance: if custom = 16 then 1 else 0