Function text.contains reffering řo another table

[petrcz]

Hi, I have two tables

In a table "Queries", column "Branded", I need a function, which check, if a string in a table "Queries", column "Query" contains any value from table "Branded", column "Query".

If yes, return "brand"

If not, return "non brand"

Could you give me a hint, how to proceed this?

[v-huizhn-msft]

Hi @petrcz,

Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. So that more more people will benefit from here.

Best Regards,
Angelia

[v-huizhn-msft]

Hi @petrcz,

Please refer to the similar thread, please feel free to ask if you have any issue.

Best Regards,
Angelia

[MFelix]

Hi @petrcz,

Not sure if I understood the correct way that you are searching, and if you are searching the full text in a value but you can add this column to your query table and then put it on a table:

Column

BRAND =
IF (
    ISBLANK ( LOOKUPVALUE ( Branded[Query], Branded[Query], Queries[Branded] ) ),
    "Not Brand",
    "Brand"
)

Final result

Regards,

MFelix