Power Query Challenge - Find Latest Value and filter out the rest

[Nothnless]

Hi, I'm Using Get&Transform in Excel which is equivalent to Power Query in Power BI. It even uses the same M language.

Is there a way to use the query to get a result that displays the following?

If there are duplicate errors then keep the latest error of those duplicates and filter out the rest.

Original table:

Time	Name	Error
1:00	John	Y
2:00	John	Y
3:00	Smith	N
4:00	Dave	Y
3:00	John	Y

Result:

Time	Name	Error
3:00	Smith	N
4:00	Dave	Y
3:00	John	Y

In this case the duplicate John's with errors were removed except for the John at 3:00

Thank you,

 

[sandy666]

it depends on the data structure
but probably(!) yes

you have two solutions so choose

I think Conditional Column is a good way

 

[Nothnless]

You two are AWESOME!

 

[sandy666]

You are welcome
Have a nice day

 

[pjmorris]

A pleasure to have helped. It occurred to me this morning I might be tempted to add a final step of highlighting relevant columns in Powerquery Editor and deleting duplicates. Just a thought.