Forum Discussion

ooctaviano's avatar
ooctaviano
Frequent Visitor
5 years ago
Solved

Max Date

I need help, I'm having issues with a measure, I have a table like this

 

 

I need a measure that brings me the last date with accidents, in this case 3/28/2021, and also the previous date with accidents.

 

I have this measure but for some reason it does not bring any date back

 

Last Date = calculate(MAX(RA[Date]),filter(RA,RA[Accidents]>0))

Also tried

Last Date = CALCULATE(MAX( RA[Date] ),FILTER( ALL( RA ), RA[Acidents] > 0 ))

but also does not work

 

It may be something with the filtres.

 

Please advise I need help

3 Replies

    • ooctaviano's avatar
      ooctaviano
      Frequent Visitor

      Same issue, still not showing the last date.

    • ooctaviano's avatar
      ooctaviano
      Frequent Visitor

      I just needed to use all instead of allselected

      Thanks a lot for the help