Count Days Since last OSHA Incident

Hi,  

I assumed that your data has more than just the 4 rows. Basically you use DATEDIFF function:

1. Count days between the last yes and the second last yes 

1. Count days between the last yes and the second last yes 
Countdays between two Yes = 
var Lastyes = CALCULATE(LASTDATE(Sheet5[Date of Incident]),
                    FILTER(Sheet5,[OSHA Recordable]="YES"))

var Seclastyes = CALCULATE(LASTDATE(Sheet5[Date of Incident]),
                    FILTER(Sheet5,[Date of Incident]<Lastyes),
                        FILTER(Sheet5,[OSHA Recordable]="YES"))

Return DATEDIFF(Seclastyes,Lastyes,DAY)

2. Count days between the last yes and now.

Countdays since recent yes = 
var Lastyes = CALCULATE(LASTDATE(Sheet5[Date of Incident]),
                 FILTER(Sheet5,[OSHA Recordable]="YES"))

Return DATEDIFF([01Lastyes],NOW(),DAY)

There is the pbix if needed.

https://qiuyunus-my.sharepoint.com/:u:/g/personal/paul_qiuyunus_onmicrosoft_com/ERdc7wQicIhEr9oL-2i5KdIB1S_837dK135IE4ANerwNvQ?e=tNc645

Best, 
Paul

Hi Anonymous ,
Try this:

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Date Diff =
VAR _currDate =
    MAX ( injTable[Date of Incident] )
VAR _pastDate =
    CALCULATE (
        MAX ( injTable[Date of Incident] ),
        ALLEXCEPT ( injTable, injTable[OSHA Recordable] ),
        injTable[Date of Incident] < _currDate
    )
RETURN
    IF (
        MAX ( injTable[OSHA Recordable] ) = "YES",
        DATEDIFF ( _pastDate, _currDate, DAY )
    )