Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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:

 

tomasferro99_0-1671463734854.png

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!

1 ACCEPTED SOLUTION
IIPowerBlog
Helper I
Helper I

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

IIPowerBlog_0-1671466009672.png

 

View solution in original post

2 REPLIES 2
IIPowerBlog
Helper I
Helper I

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

IIPowerBlog_0-1671466009672.png

 

Anonymous
Not applicable

It was so simple, thanks! 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors