Show Latest Value & Last N Values

I apologise in advance that I cannot show any data so will try to describe and provide rough examples.

I am trying to display the latest given grade (A, B, or C) for a component for an overall item.

I have multiple components for multiple different items.

I also want to show the last N amount of grades for each component. 

I have achieved a table that shows this but the problem is it also has rows for each old component grade given - I just want to see the component's latest grade and it's history.

The above is an example of what I want. I'll add other columns as well, notes regarding the grade, date the grade was assigned, et cetera. 

I have only ever used Excel up to now and am still trying to understand how Power Bi passes information; Excel does it Cell by Cell which means you can easily review every variable at every step of the way but Power Bi is able to accomplish this task to a better degree and can be incorporated with other dashboards.

Thank you for your time and consideration.

Kind Regards,

AnonymousEngi