Forum Discussion

cmccully's avatar
cmccully
Icon for Helper I rankHelper I
7 years ago
Solved

Find a value associated with the latest date

I have a list of mileage reads and want to get the reading associated with the latest mileage date.    Because mileages are sometimes corrected I cannot simply grab the highest mileage reading beca...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    This measure works

    Measure = CALCULATE(SUM('Sheet 1'[METER]),LASTDATE('Sheet 1'[METER_DATE]))

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello there, nice, it worked on my side as well. One question... why can't I substitute the lastdate() with min() or max()?

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

You are welcome.  The LASTDATE() function returns a table of 1 row and 1 column whereas the MAX() function returns a single scalar value.