Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Hidding old values

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!

2 Replies

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      It was so simple, thanks!