Share some sample data (which i can paste in an Excel file) and a table showing the words that you would like to be treated as lock.
Really 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:
3) text.contain ("lock", "padlock", "locksmith")
The above 1) and 2) will use the nested text.splitany() by space
Is this the result you are expecting (see the second column)?
Yes, I think so. Well, I'm ready to embrace the DAX now. Could you please show me how to do it?
You may download my solution Excel file from here. Go to PowerPivot > Manage
Hope this helps.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.