The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi there,
I am using containsstring to check the spelling of my sales managers... 😉
I am using containsstring to filter valid entries and create a link to the spelling error. I call it the Wall of Shame.
However, when I have additional words in the field, it does not work. Long story short:
as you can see "kein interesse" should result in a blank, but lines 5 and 6 of the lower table has a result. I have narrowed it down to everything that has
a) a special character and
b) inbound in front.
My understanding of CONTAINSSTRING is that it should find the string. What am I doing wrong?
Thanks y'all
Marko
Solved! Go to Solution.
I think it is the order of arguments. You need to change as follows
CONTAINSSTRING ( betreff, "string" )
I think it is the order of arguments. You need to change as follows
CONTAINSSTRING ( betreff, "string" )
User | Count |
---|---|
27 | |
10 | |
8 | |
7 | |
5 |
User | Count |
---|---|
33 | |
14 | |
11 | |
10 | |
8 |