Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good afternoon
Does anyone know how I do (what formula I use) to search the fields that have a certain fragment of a text?
For example, I need to know which rows in the "Description" field of a table have the "ABC" snippet.
DESCRIPTION TEST
ABCX Yes
ABDF No
AGFA No
AFGD No
If I use the IF formula it does not work because it would only search the field that has only the ABC section. But my goal is to know the lines that have this fragment, but not necessarily be ONLY it.
Solved! Go to Solution.
This should do the trick for you:
Column = SWITCH ( TRUE (), FIND ( "ABC", Table1[Description], 1, 0 ) = 1, "YES", "NO" )
Proud to be a Super User!
This should do the trick for you:
Column = SWITCH ( TRUE (), FIND ( "ABC", Table1[Description], 1, 0 ) = 1, "YES", "NO" )
Proud to be a Super User!
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |