Showing results for 
Search instead for 
Did you mean: 
Thomas897 Regular Visitor
Regular Visitor

Keep last update of a cell

Hi everyone,


I have a column where are written in how many miles a car needs to go to the car maintenance and I need to make a graph about it. This graph is divided between 4 columns:

  • Maintenance to do
  • To do in 0 < 5 000 miles
  • To do in 5 000 < 15 000 miles
  • To do over 15 000 miles

Each week I receive uptade and sometimes a car go from one colum to another but there is a problem because the car is counted twice.

Do you know how I can keep only the last update of a car ?


Thanks guys Smiley Happy

vanessafvg Super Contributor
Super Contributor

Re: Keep last update of a cell

@Thomas897 is it possible to post how your data is stored?  i.e teh table view with an example of how it looks, showing a line where the data falls into both categories?

Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 47 members 891 guests
Please welcome our newest community members: