Keep last update of a cell

[Thomas897]

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 🙂

[v-shex-msft · Accepted solution]

HI @Thomas897,

It will be help if you share some sample data to analysis.

For your scenario, I think you need to add a calculated column to add and check range on your records.

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

You can use car id to filter table and return the max date as the last update date.

Sample:

Last Update=
CALCULATE (
    MAX ( table[date] ),
    FILTER ( ALL ( table ), [card id] = MAX ( Table[car id] ) )
)

Regards,

Xiaoxin Sheng