Hidding old values

Anonymous — Mon, 19 Dec 2022 15:37:03 GMT

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!

Re: Hidding old values

IIPowerBlog — Mon, 19 Dec 2022 16:07:00 GMT

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

Re: Hidding old values

Anonymous — Mon, 26 Dec 2022 12:01:34 GMT

It was so simple, thanks!

topic Re: Hidding old values in DAX Commands and Tips

Hidding old values

Re: Hidding old values

Re: Hidding old values