Forum Discussion

ny3rs's avatar
ny3rs
New Member
4 years ago
Solved

Creating a report on max values from a table

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!

 

 

Need Help
  • sokg's avatar
    sokg
    4 years ago

    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!

3 Replies

  • sokg's avatar
    sokg
    Solution Supplier
    4 years ago

    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!