I would like to count the periods of employee absence > 1 day as 1 occurrence. If an employee is absent 3 consecutive days, then this should count as 1 occurrence. employee empID eventdate comments points

Hi @lizbethl4 For better help, it is recommended to share test data in a pibx file. Following the logic of the previous post, it will be something like this: Cumulative Point = VAR vCurrentDate = 'Test Data'[Charge Date] VAR _Ini = 'Test Data'[Cumulative Days Count] - 1 VAR _StartDate = DATEADD…