Forum Discussion

kcantor's avatar
kcantor
Community Champion
9 years ago
Solved

PowerQuery Contains

I have two tables that have a part number field. Is there a way in Power Query to see if Table1[VendorItem] contains the text found in Table2[Part#] ? They would not be exact matches so a merge is o...
Need Help
  • kcantor's avatar
    kcantor
    9 years ago

    Anonymous send me a wonderful little snippet of Dax for a table. It was a thing of beauty and worked beautifully.

    new table = GENERATE(
	Table1,
	FILTER(
		Table2,
		NOT(
			ISERROR(
				FIND(
					Table2[PART#],
					Table1[Vendor Item]
				)
			)
		)
	)
)
kcantor's avatar
kcantor
Community Champion
9 years ago

Anonymous send me a wonderful little snippet of Dax for a table. It was a thing of beauty and worked beautifully.

new table = GENERATE(
	Table1,
	FILTER(
		Table2,
		NOT(
			ISERROR(
				FIND(
					Table2[PART#],
					Table1[Vendor Item]
				)
			)
		)
	)
)
  • blopez11's avatar
    blopez11
    Super User
    9 years ago

    Awesome, I'll bookmark this for future reference

    Thanks for sharing

     

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    kcantor

     

    An excellent solution. You could mark your answer as solution to close this thread and help others to know the right answer.

     

    Best Regards,

    Herbert