Forum Discussion

Jun_Wang's avatar
Jun_Wang
Icon for Advocate I rankAdvocate I
7 years ago
Solved

any 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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

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

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

How do we make the software understand that block should be ignored but padlock should be considered (when there is no space between pad and lock)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

We created a column on a condition saying that, if the string contains "block" then block else "lock".

Power BI will search for the defined string in the condition and will reteun the expected results.

 

Hope I have answered your question.

 

Regards,

Pavan Vanguri.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    No, you have not.  Suppose there was a word bullock, you would have to create an exception for this as well.  There will be countless such words.