Forum Discussion
AdministratorCompare duplicates with another column
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!
5 Replies
- Ahmedx
Super User
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 
Syndicate_AdminAhmedx, thank you very much! It worked perfect...!
- 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, 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
try to write like this.
BUT of course it will be better if you first remove the spaces in the power query.
