Forum Discussion
Look up value from an unrelated table using text comparison
Try a new column like
New column in Table 1 = minx(filter(table2,search(Table2[Short Description],Table1[Description],1,0)>0),Table2[Sub-Category])Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin
Super UserTry a new column like
New column in Table 1 = minx(filter(table2,search(Table2[Short Description],Table1[Description],1,0)>0),Table2[Sub-Category])
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin
Thank you, that did it!
I was on the right track with the FILTER function, but I didn't know how to derive a scalar value from the resulting table. MINX seems to work fine, though I wonder if there are other ways.
Thank you!