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

[franzotti]

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

My Data Base:

[Waldo35 · Accepted solution]

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

[franzotti]

Thank you very much,
I wanted to use DAX, so I put double quotes to identify the table and it worked.

[Waldo35]

this takes the text between a space and a ".

"""" is interpreted as "

[franzotti]

But my base is not standard and there are monitors using 4 digits (18.5") for the description and others with 3 digits for the description (27").

So I was using switch to identify only the specified ones.