Forum Discussion
ooctaviano
5 years agoFrequent Visitor
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
- amitchandakSuper User
- ooctavianoFrequent Visitor
Same issue, still not showing the last date.
- ooctavianoFrequent Visitor
I just needed to use all instead of allselected
Thanks a lot for the help