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 ) )
No employment type filtering
Copy this HTML code:
Preview:
open_in_newInstructions on embedding in Medium
Comments