All - Hours (Rolling)

PHOTO EMBED

Thu Aug 05 2021 05:01:32 GMT+0000 (Coordinated Universal Time)

Saved by @cnewnham

All - Hours (Rolling) = CALCULATE(SUM('1 Combined - Frequency Data'[Hours Worked]),
    DATESINPERIOD (
        '1 Combined - Frequency Data'[Month and Year],
        LASTDATE ( '1 Combined - Frequency Data'[Month and Year] ),
        -12,
        MONTH
    )
)
content_copyCOPY

No employment type filtering