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.
I have a column of comments in Table1. I have a column of keywords in Table2.
I want to flag TRUE or FALSE if the comments from Table1 contain any of the keywords from Table2 for each record. The complete keyword needs to be present in the comment.
Thanks.
Scott
Solved! Go to Solution.
You may refer to the DAX below.
Column = COUNTROWS ( FILTER ( Table2, SEARCH ( " " & Table2[keywords] & " ", " " & Table1[comments] & " ", 1, 0 ) > 0 ) ) > 0
You may refer to the DAX below.
Column = COUNTROWS ( FILTER ( Table2, SEARCH ( " " & Table2[keywords] & " ", " " & Table1[comments] & " ", 1, 0 ) > 0 ) ) > 0
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |