Compare duplicates with another column

[Syndicate_Admin]

Hello everyone

I am new to power BI and I would like to help me in this consultation. I have the following table:

to which I need to do the following validation:

- identify the rows with duplicate data in the field "Data 2"

- check if of these identified rows, the data in the "Data 1" field are the same

- if they are equal, place "OK" in the "Result" field

- if there are differences, place "fail" in the "Result" field

The result would be something like this:

Thank you for your help!

[Ahmedx]

try to write like this.
BUT of course it will be better if you first remove the spaces in the power query.

[Syndicate_Admin]

Ahmedx, an additional query, in my table, in the fields data 1 and data 2, there may be gaps. I have noticed that he still considers them as "failure", there is a way that he does not consider them and instead, also indicate "OK"?

Thank you!! You're helping me a lot.

[Ahmedx]

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

[Syndicate_Admin]

Ahmedx, thank you very much! It worked perfect...!

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RhlkvVbyABYL0RfUO?e=zoYBzR