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 All:
I am trying in to write a formula so that the formula 1st looks at the Keyword Column, see the keyword then searches the Search Query Column and if it contains keywords found in the Keyword Column then the output will be "Keyword Found". Any help would be appreciated.
Solved! Go to Solution.
You can use below formula
Result = IF(ISNUMBER(SEARCH('Table'[Keyword],'Table'[Search Query],,BLANK())),"Keyword Found")
I have one more question that is relevent to the revious answer.
Suppose the words in the search query match the keywords but the words are in a different order and have extra words in it. Is there a formula that can find the different order of words and still count as a keyword found for the results? Screenshot below of the problem.
You can use below formula
Result = IF(ISNUMBER(SEARCH('Table'[Keyword],'Table'[Search Query],,BLANK())),"Keyword Found")
Covering 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 | |
97 | |
78 | |
68 | |
55 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |