Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
80 | |
67 |