Forum Discussion
Count Days Since last OSHA Incident
Hello, I'm stumped. I need help creating a count of days between "Yes" recordable events, and count of days since our most recent "Yes" OSHA Recordable. Date of Incident Incident Type ...
Anonymous
In this case, I would suggest you to create a column instead of a measure. See my sample below, hope it makes sense for you.count since last yes = IF ( Sheet6[OSHA Recordable] = "Yes", DATEDIFF ( CALCULATE ( MAX ( [Date of Incident] ), FILTER ( Sheet6, [Date of Incident] < EARLIER ( Sheet6[Date of Incident] ) ), FILTER ( Sheet6, [OSHA Recordable] = "Yes" ) ), [Date of Incident], DAY ), BLANK () )Best,
Paul
Anonymous
In this case, I would suggest you to create a column instead of a measure. See my sample below, hope it makes sense for you.
count since last yes =
IF (
Sheet6[OSHA Recordable] = "Yes",
DATEDIFF (
CALCULATE (
MAX ( [Date of Incident] ),
FILTER ( Sheet6, [Date of Incident] < EARLIER ( Sheet6[Date of Incident] ) ),
FILTER ( Sheet6, [OSHA Recordable] = "Yes" )
),
[Date of Incident],
DAY
),
BLANK ()
)
Best,
Paul
Awesome this is great, thank you so much!