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,

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

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

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

Many thanks!!!!

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

    Hi,

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

    Hope this helps.