Help with my comment added column

[Anonymous]

Hi all, any support would be appreciated.Need Help

I have a table with column Question_Name that are similar to each other Communication skills and Area of improvement identified : Communication skills. The first is a yes or no answer, the second provides me with the reason for that answer and I want to match them up for the same eval_key so when I filter to No I get the comments why the answer is no. Been around the houses trying to match up new columns I've added to get a separate column where No is selected I get the comments from that additional column but it's just not worked with the below:-

Comment Added = IF(AND('dw Verint_Answers'[Comment]='dw Verint_Answers'[Question_Name],'dw Verint_Answers'[eval_key]='dw Verint_Answers'[eval_key - Copy]),'dw Verint_Answers'[Answer])

Can someone help fix this or come up with a better way to filter to comments when the answer is yes no please?

 Sample data

Question_Name	Answer	eval_key
Communication skills	No	1234
Area of improvement identified : Communication skills	Needs to improve sales	1234

[Anonymous]

Yes, you've got it. 🙂

[ray_aramburo]

What I would do is use Power Query and separate the rows (by duplicating the query and filtering) by the Skills and the Areas of Improvement. Then, merge the queries using the eval_key and extract the areas of improvement comment. Keep in mind that you might need to use another column as a key as well in case eval_key column doesn't have unique values after separating the data. 

[ray_aramburo]

If I understood correctly, you want to get a new column that indicates if your Answer= No (or Yes) then you want to show "Needs to improve sales", is that correct?