Search in Lookuptable and return value

[Stever25]

Hello,

I search a solution since weeks for the following problem. 

We have millions of products with a productdescription from several producers. In every description is exactly one part of text which describe a feature of the product. This feature we like to analyse. For this we build a powerfull lookuptable. In one column is the part of the text we expect in the description, in the second table we have the feature we like to analyse.

Has anyone an idea for a measure? There is no relation between the tables.

I like to solve it with a measure. I have a poor solution with a calculate column but with very poor perfomance.

Thx

[AlB]

Hi @Stever25 

Do you want to show the code you currently have for the column? It will help understand the requirement. Best if you can share some sample data as well, in text-tabular format

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers