Remove Duplicates saving one with higer value

[TDys]

Hi 

Ho do I remove duplicates for same SERIALID and SAME DATE saving only one with higher SMU value. Table has more than 1000 SERIALID. Some SERIALID do not have double entries.

Thank You in advance.

[VasTg · Accepted solution]

@TDys

Here's the entrance.

Here's the exit:

If it helps, mark it as a solution

Congratulations are also good

[TDys]

Thank you for super fast help. Appriciare it.

Best regards;

Tomasz

[VasTg]

@TDys 

Post the sample data in text format so that we could copy paste and work on it.

A screenshot doesn't help us at all.

Refer..

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490