Forum Discussion

New Member

9 years ago

Solved

Injury Frequency Rate Moving Annual Calculation

Hi, trying to calculate Injury Frequency Rates. Able to do YTD calculation and also Fiscal year, but need to calculate the moving annual Injury Frequency Rate on a monthly basis. Anyone able to help?...

v-qiuyu-msft
9 years ago
Hi GregM,

In your scenario, check if the Month columns in those two tables are Date type. If not, please create a calculated column to return it as Date type.

Date = DATEVALUE("1-"&'Hours Table'[Month])

Then Create a calculated column to get moving 12 month LTIRF.

Moving12LTIRF = CALCULATE(SUMX( ALLSELECTED('LTI Table'), 'LTI Table'[LTI])/SUMX( ALLSELECTED('Hours Table'), 'Hours Table'[Hours])*1000000,
    DATESINPERIOD (
        'LTI Table'[Date],
        LASTDATE ( 'LTI Table'[Date] ),
        -12,
        MONTH
    )
)

Best Regards,
Qiuyun Yu
Moving12LTIRF.zip81 KB

v-qiuyu-msft

Community Support

9 years ago

Hi GregM,

In your scenario, check if the Month columns in those two tables are Date type. If not, please create a calculated column to return it as Date type.

Date = DATEVALUE("1-"&'Hours Table'[Month])

Then Create a calculated column to get moving 12 month LTIRF.

Moving12LTIRF = CALCULATE(SUMX( ALLSELECTED('LTI Table'), 'LTI Table'[LTI])/SUMX( ALLSELECTED('Hours Table'), 'Hours Table'[Hours])*1000000,
    DATESINPERIOD (
        'LTI Table'[Date],
        LASTDATE ( 'LTI Table'[Date] ),
        -12,
        MONTH
    )
)

Best Regards,
Qiuyun Yu

Moving12LTIRF.zip81 KB