Forum Discussion
Jun_Wang
Advocate I
Advocate Iany function can do exact match (text) in power query?
I'm quite new to power query. I used to run some M functions in power query to do keywords searching and assign these rows with specific keywords to a category. But it has some issues now. I need exa...
Jun_WangAdvocate I
Advocate IReally appreciated your help. Here are some text.
I cleaned the data from R, so there is no singular and plura problem. My predefined list is shorten the if-else will go through in the order like below:
1) List.ContainsAll({"door","lock"}
2) List.ContainsAll({"key","lock"}
3) text.contain ("lock", "padlock", "locksmith")
The above 1) and 2) will use the nested text.splitany() by space :)
Many thanks.
| block toilet haywards ac substation. |
| wdv supply chain padlock road gate |
| dvk lock toilet cubicle door portacom smoko sheed missing lock |
| entry door design hand injury potential due proximaty lock door jamb |
| sbk southbrook substation - block toilet |
| isl - break door lock transfield office |
| investigate blockage drain main driveway |
| haywards toilet block ac |
| ay lock mechanism switchyard b man gate accept key |
| condenser internal door lock ac fall apart |
| esni lock gate |
| hot water unit toilet block need replacement leak flood toilet block |
| wvy - rust screw exterior amenity block |
| wairaki investigation electronic door lock control door. need replacement |
| igh - unblock drain |
Ashish_Mathur
Super User
Super UserHi,
Is this the result you are expecting (see the second column)?
- Jun_Wang
Yes, I think so. Well, I'm ready to embrace the DAX now. Could you please show me how to do it?
Many thanks!!!!
- Ashish_Mathur