Forum Discussion
Solved
M- text contains
Hi all, I am importing a report that consists of multiple checklists. In each checklist there are four questions that are the same in every checklist. They are all questions related to someone’s ski...
bhard Try:
if Text.Contains([QuestionText], "Does the site have the skills?") or Text.Contains([QuestionText], "What skills are required?") or Text.Contains([QuestionText], "Is there a skills gap?") or Text.Contains([QuestionText], "What is the skills gap remediation action?") then 1 else 0)
Note, you could also drop the Text.Contains at this point and just use [QuestionText] = "What is the skills gap remediation action?" for example.
