Creating a report on max values from a table

[ny3rs]

Hello, I have a table which captures monthly mileage values of suer's cars. Thus for each car I have multiple entries. 

I want to create a report in which I can use the date (i.e. year) as well as various filters derived from the car_id to analyze the mileage data. So somehow I need to capture the max value for a given car for the selected period (as in a longer period there could be multiple entries). How should I do this best? Create a new table that has these values on a quaterly or annual basis or work with calculated measures?

This is how my table looks like (the submit_date is irrelevant for me):

I am very new into PowerBI so sorry for such a basic question.

I'm greateful for every hint!

[ny3rs]

Thanks @sokg , this helped me a lot!

[sokg]

Hi @ny3rs 

Glad to help you!!!

[sokg · Accepted solution]

Hello @ny3rs 

Try this

KMValue =
VAR MaxDate = MAX(Table[km_date])
VAR Result =
CALCULATE(
     MAX(Table[km_value]),
     km_date = MaxDate 
)
RETURN
     Result

Hopefully this is what you are looking for!