Forum Discussion

AJ1426's avatar
AJ1426
New Member
6 years ago

Days from incident type (count)

I have the following DAX configured, I need it to release the days from the last type of injury specified. I have a table with the dates of the incident, and the types of injuries

contar desde el último sí -
IF (
    Sheet6[OSHA Recordable] - "Sí",
    DATEDIFF ( CALCULATE ( MAX
        (
            [Date of Incident] ),
            FILTER ( Sheet6, [Date of Incident] < EARLIER ( Sheet6[Date of Incident] ) ),
            FILTER ( Sheet6, [OSHA Recordable] ? "Yes" )
        ),
        [Fecha del incidente],
Date of incidentType of incident
1/1/2020

Near Miss

2/4/2020Lost time
2/5/2020

First Aid

3/5/2020Restricted activity
3/5/2020Recordable
4/15/2020Lost time
4/23/2020First Aid

I need help reflecting the count of the days, but I'm stuck

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    AJ1426 can you clarify what you want to do. In the past I worked for a client on these injury reports, like a day since last recordable and OSHA calculations etc, I have a bit of domain knowledge but not sure what you are trying to achieve here. Explain the expected output, it will help immensely to provide the solution.