Hi Ruth, I think there is a bit of confusion on what exactly is going on with the formulas you present. I say this because I was left with the feeling that you were expecting the rows to be treated as a list of words. That doesn't happen. If you remove the "selectedvalue" the formula will work the same (in the case presented). The test that is done is to check if "hors" exists on the whole string, and it does. The CONTAINSSTRINGEXACT from my point of view is working as expected.
hello Ruth, if the only difference is that one is case-sensitive and the other not, it could be simpler to have only one function with an additional paramer to select case or not case-sensitive.... it seems extrange to use 2 functions so similar.
Yes, I agree with you. They could have that as an extra parameter and then create a true EXACT measure. That would be wonderful, thanks for sharing. /Ruth
Agree! It's OK to have one function that's case sensitive and another that is not, but it would be great to have one simple function that search for exact words. Saludos y gracias por la clase!!
I'm a bit surprised that DAX didn't already have these functions before. M has Text.Contains, so I guess I just assumed that DAX had a similar one (obviously I had never had to use it). Anyhow, it's good that we have them in our DAX toolbox now. Thanks, Ruth!
No direct function, you had to use Search and Find and sumx to get something similar! The fact that you didn’t know is a good thing, meaning you were using Power Query for that ;) /Ruth
Great video! These functions look like they could be very useful when working with categorical data. I think that it is searching for if say "hors" is contained in the text. Try searching for "Hors" and it will not work.
What would be really cool and really useful is if DAX and M had the search and replace functionality that Word has. Switches to indicate that you want an exact match, whole words only, ignore punctuation, ignore white space, etc. would be extremely powerful and they could wrap it all in one function for Containsstring and one for Find. They could get rid of Search or make Search have the exact same functionality as Find.
Hi Ruth,
I think there is a bit of confusion on what exactly is going on with the formulas you present.
I say this because I was left with the feeling that you were expecting the rows to be treated as a list of words.
That doesn't happen.
If you remove the "selectedvalue" the formula will work the same (in the case presented).
The test that is done is to check if "hors" exists on the whole string, and it does.
The CONTAINSSTRINGEXACT from my point of view is working as expected.
Thanks for the feedback!
/Ruth
Hi Ruth, thanks as always.
You welcome Stephen and thanks for all your support!
/Ruth
¡Excelente Ruth! gracias por la explicación.
De nada y buen fin de semana!
/Ruth
HELP: SQL has different LIKE operators with '%', for example: WHERE CustomerName LIKE 'a%'. Is there a similar funtion in DAX?
hello Ruth, if the only difference is that one is case-sensitive and the other not, it could be simpler to have only one function with an additional paramer to select case or not case-sensitive.... it seems extrange to use 2 functions so similar.
Yes, I agree with you. They could have that as an extra parameter and then create a true EXACT measure. That would be wonderful, thanks for sharing.
/Ruth
Agree! It's OK to have one function that's case sensitive and another that is not, but it would be great to have one simple function that search for exact words. Saludos y gracias por la clase!!
De nada y buen fin de semana!
/Ruth
I'm a bit surprised that DAX didn't already have these functions before. M has Text.Contains, so I guess I just assumed that DAX had a similar one (obviously I had never had to use it). Anyhow, it's good that we have them in our DAX toolbox now. Thanks, Ruth!
No direct function, you had to use Search and Find and sumx to get something similar!
The fact that you didn’t know is a good thing, meaning you were using Power Query for that ;)
/Ruth
Hello Ruth, Is it possible to write a DAX function using this "CONTAINSSTRING" where the "true" and "false" values are converted to 1 en -1?
Can we search by Selected Value (Input coming from Slicer) in a column that contains multiple texts. Returning True or False
Hi ruth
i want to include containsstring in if condition
how can i do this?
Hello! Can you only search for one text value or can you search for multiple values in the same DAX query?
Wondering the same!
It is :
community.powerbi.com/t5/Desktop/Search-for-multiple-text-in-one-column-with-OR/td-p/469698
/Ruth
Great video! These functions look like they could be very useful when working with categorical data. I think that it is searching for if say "hors" is contained in the text. Try searching for "Hors" and it will not work.
Yes!! They were indeed needed :)
/Ruth
What would be really cool and really useful is if DAX and M had the search and replace functionality that Word has. Switches to indicate that you want an exact match, whole words only, ignore punctuation, ignore white space, etc. would be extremely powerful and they could wrap it all in one function for Containsstring and one for Find. They could get rid of Search or make Search have the exact same functionality as Find.
That would be really amazing!! Who knows? Maybe soon :)
/Ruth
HOW WOULD YOU DO CONTAINSSTRING FOR APPLE OR CAR ?
thansk
WOW!!!!!!!!!!!!!!!!!!!!!!!!!!!
🥳🥳🥳
Hi Ruth could you please give real time example where it will be useful ..thanks for this video..
I will as soon as I find one ;)