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 w...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    ooctaviano , Try a measure like

     

    MAXX(filter(allselected(RA),RA[Accidents]>0),RA[Date])

amitchandak's avatar
amitchandak
Super User
5 years ago

ooctaviano , Try a measure like

 

MAXX(filter(allselected(RA),RA[Accidents]>0),RA[Date])

ooctaviano's avatar
ooctaviano
Frequent Visitor
5 years ago

I just needed to use all instead of allselected

Thanks a lot for the help