cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: any function can do exact match (text) in power query?

Hi,

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.

Jun_Wang Frequent Visitor
Frequent Visitor

Re: any function can do exact match (text) in power query?

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:

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 Smiley Happy

 

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
Super User
Super User

Re: any function can do exact match (text) in power query?

Hi,

Is this the result you are expecting (see the second column)?

Untitled.png

Jun_Wang Frequent Visitor
Frequent Visitor

Re: any function can do exact match (text) in power query?

Yes, I think so. Well, I'm ready to embrace the DAX now. Could you please show me how to do it?

Many thanks!!!!

Highlighted
Super User
Super User

Re: any function can do exact match (text) in power query?

Hi,

You may download my solution Excel file from here.  Go to PowerPivot > Manage

Hope this helps.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 237 members 2,516 guests
Please welcome our newest community members: