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 v...
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!

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!