Hidding old values

[Anonymous]

Hi! I'm new to Power Bi and I'm struggling with this work.

Here in my workplace we have a vending machine that expends the tools we use to work. Some of this tools has a certain lifetime such as work gloves, respiratory masks, etc. and the employee has to throw away the one they've been using and expend a new one. 

Here is an example of the table:

The column "Days" shows the days since the last time the person expended the product (in this case, an anti-cut glove).

For example, Thomas has expended this kind of gloves 32 days ago.

The thing is that, for example, James, Mark and Brad has expended gloves two times, so their name shows up two times. I want the table to only show once the name of the employee and to use the latest value of the column "Days" (i.e.: Brad, 23 days ago.)

Sorry if my english wasn't clear, I haven't use it in a while. I'll stay tuned if anyone need more information to answer! 

Thanks in advance!

[IIPowerBlog · Accepted solution]

hello, in your columns right click the days and select Maximum 

[Anonymous]

It was so simple, thanks!