Formula to count the number of days since the last accident excluding certain data.

[98Hodge]

Hi,

I'm currently using this formula: 

Days Since Last Accident =

VAR _last=maxx(FILTER('All_Data','All_Data'[Type of report]="Accident"),'All_Data'[Date and time])

return DATEDIFF(_last,TODAY(),DAY)+0

to count the number of days since the last accident.

I need to add another variable to this formula that excludes "Property Damage" accidents. This data would be found in 'All_Data'[Type of Injury].

Is there any way to add this to my formula to exclude this data?

[Greg_Deckler · Accepted solution]

VAR _last=maxx(FILTER('All_Data','All_Data'[Type of report]="Accident" && 'All_Data'[Type of Injury] <> "Property Damage"),'All_Data'[Date and time])
return (TODAY() - _last) * 1. + 0