Forum Discussion
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 out of the question.
For example, the vendor item might be T49 and the [Part#] might be T49WHRH to specify color options amoung other things.
Any ideas on making this happen?
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] ) ) ) ) )
6 Replies
Trying to understand what your overall goal is? Maybe able to offer options if we understand what you are trying to achieve
I think you would want to go with a calculated column
I'm not sure if there would be multiple matches in your data set during the lookup but you can take a look at the following as it may apply to your case
Hope this helps
