Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Multiple Keywords Match Power Query

Hi Need,


Help is Identifying Whether My "Error Message" Column has Multiple Keaywords to be matched for "Keywords" Column in Power query. I have Sampled to to 3 lines of error message. I am able to match with one keyword for my other project using Text. Split & List. Intersect but for multiple words i am getting null valuse. Please let me know if anyone have any ideas.


Error MessageKeywords
 Member has not met Continuing Work Test to receive Employer Additional contributionhas not met
Contribution header xx,xxx,xxx, is already authorised,contribution for plan member x,xx,xxx must be processed already authorised,contribution for plan member 
Contribution Transaction Request (CTR) processing cannot be completed until the outstanding Member Registration Request (MRR) is completed – refer to EDI ID (0011001100) received (01/06/2020) for the MRR details.Contribution Transaction Request (CTR) processing cannot be completed
Super User III
Super User III

Hello @Jazz-123 


I suppose you have to tables. In this case just join both table on your error message column and then expand the long description.


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun


Helpful resources



We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors