Forum Discussion

petrcz's avatar
petrcz
Regular Visitor
9 years ago

Function text.contains reffering řo another table

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?

Need Help

3 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    9 years ago

    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

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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