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

98Hodge — Mon, 12 Sep 2022 11:12:32 GMT

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?

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

Greg_Deckler — Mon, 12 Sep 2022 11:53:28 GMT

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

topic Formula to count the number of days since the last accident excluding certain data. in DAX Commands and Tips

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

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