Classify the type of comments from one column into another

[Syndicate_Admin]

Hello good, I have a comment column associated with a customer column.
There is another column that indicates the date that comment was generated and another column that associates the quality of the comment, and it can have the character of 'success' or 'failure'.
---->Customer-Comment-Date that was generated-Comment status(failure, success)<---- something like that would be the columns of my data
Each customer can have more than one comment associated with it, so for example, there can be 3 rows for the same customer.
Depending on the type of comment there is a rating (if the comment has a customer subscribes X agreement, then if the comment has to subscribe Y agreement then if, if the client does NOT subscribe agreement then NO)
What I need to do is generate a column that indicates 'YES' and NO' for each classification, by a customer. If the client associates the X convention, I need another column that says YES (otherwise it would be a failure that would have a NO category in the same column that I generate). If the customer associates Convention Y, I need another column that says YES or NO for each customer depending on the quality of the comment (the type of agreement subscription)
My idea was to use CONTAINSSTRING, but I don't recognize the function,
if CONTAINSSTRING([COMMENT], "subscribes convention], then "SI" else "NO"
If there's any suggestion otherwise, it would be super.
I'll be vigilant

[Syndicate_Admin]

What else do you need to help me?, look I attach a photo of the type of comment, because the textcontains takes part of the word, that is if it says for example 'the customer pays' or 'ABONA WILL X FEES', if I place the text contains, and I want to place only those who have already paid, it still takes the comment of ABONAA , because the word ABONA (with which I will classify whether the customer actually paid and not in the future) is within PAYMENT,

Do you understand me?

[ibarrau]

Hi. I don't think I have followed all the logic but the idea is clear. If you have problems with containsstring in DAX you can try doing this in Transform Data (Query editor) with Power Query. This functions should work for that:

https://docs.microsoft.com/en-us/powerquery-m/text-contains

Hope that helps,