Forum Discussion

Helper I

8 years ago

Solved

help with a custom function

Hello, how to simplify the function if the query? (Table.AddColumn) too lazy to write up to 20 function attachments if let Souce= {"power querry","poweer query","pooower que1ry"}, #"Ta...

Need Help

ImkeF
8 years ago
Seems that you're looking for a partial-match-lookup, where you can put your search-values in a table. Please check this post:
https://community.powerbi.com/t5/Desktop/joinAlgorithm-and-keyEqualityComparers/m-p/182148#M79842

Imke Feldmann
www.TheBIccountant.com -- How to integrate M-code into your solution -- Check out more PBI- learning resources here

ImkeF

Community Champion

8 years ago

Seems that you're looking for a partial-match-lookup, where you can put your search-values in a table. Please check this post:

https://community.powerbi.com/t5/Desktop/joinAlgorithm-and-keyEqualityComparers/m-p/182148#M79842

Imke Feldmann

www.TheBIccountant.com -- How to integrate M-code into your solution -- Check out more PBI- learning resources here

mechanix85

Helper I

8 years ago

ImkeF, cool! Thank you:smileyhappy:

mechanix85
Helper I
8 years ago
It works, but it's very slow for my table (100,000 lines of the Product Reference), taking into account the links. Are there any other options?

Forum Discussion

help with a custom function

Related content

Custom function with Table.TransformRows

Invoke Custom Function

null input parameters custom function

Integrate Custom Function

DATESYTD function