Identifying duplicate rows

[sparker22]

Hi,

I have a table of referral profile information containing fields like name, DoB, email, address etc.

If a new referral arrives, that has the exact information as a referral already in the table, I would like to be able to identify this.

Equally, I would like to be able to identify instances where not identical but similar to previous referrals.

See image below for examples and expected output.

What is the best way to go about this? Also open to other ways of doing this!

Many thanks

[Anonymous]

Hi @sparker22 ,

May I ask if your problem has been solved. If the above reply was helpful, you may consider marking it as solution. If the problem is not yet solved, please feel free to ask us a question.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vicky_]

I think you're looking for something that is pretty similar to this: https://community.fabric.microsoft.com/t5/Desktop/Show-previous-value-of-specific-customer/m-p/29522...

As for the similar to previous records, i think you'll need to be more specific with the criteria for what counts as a similar entry (i.e what fields can differ by how much). It will be a lot harder to do this with strings than other data types though.