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 IThanks Pavan, but this fix is not very ideal to me. My dataset normally has 10k rows, the "block" is not the only possible word containing string "^lock". It could be blockade, block, blockage, even sherlock........
I reckon exact match would be easier :)
Ashish_Mathur
Super User
Super Userpadlock is not an exact match. Therefore why should that be a part of your result?