Forum Discussion
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" " )
My Data Base:
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
4 Replies
Waldo35Helper I
this takes the text between a space and a ".
"""" is interpreted as "
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.
- Waldo35
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
Thank you very much,
I wanted to use DAX, so I put double quotes to identify the table and it worked.
