Count no.of days an event/events don't occur in a month

[spandana]

I have data that gives the alerts for an application. What I am struggling to find is to calculate the days where there is no alert. I want to be able to calculate the number of days where an alert did not occur.

Please help 

[v-kelly-msft]

Hi @spandana ，

Could you pls provide some sample data with expected output for test?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!