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.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 110 members 1,039 guests
Please welcome our newest community members: