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 there, new to BI and loving it so far. I would like to do the following:
Create a custom column on one sheet, which compares the string in one of the Columns (Let's say Column A) against the space-delimited string (first word) in one of the Columns (Column B) on a seperate sheet. If the string in Column B is contained anywhere in Column A, return TRUE, else FALSE.
Any help is appreciated!
Solved! Go to Solution.
According to your description, you have "find string" in Column A, then you want to search Column A, if the delimited string is included in any Column A entry, then return TRUE, otherwise FALSE. Right?
In this scenario, you can put SEARCH() function into SUMX() to get the total index for each delimited string. Please see my sample below:
Column = IF(SUMX(String,SEARCH(Word[Word],String[String],,0))>0,1,0)
Regards,
According to your description, you have "find string" in Column A, then you want to search Column A, if the delimited string is included in any Column A entry, then return TRUE, otherwise FALSE. Right?
In this scenario, you can put SEARCH() function into SUMX() to get the total index for each delimited string. Please see my sample below:
Column = IF(SUMX(String,SEARCH(Word[Word],String[String],,0))>0,1,0)
Regards,
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |