When you get the March update installed, give this a go:
Injuries LY =
VAR LYValue =
Calculate([Total Injuries],SAMEPERIODLASTYEAR('Date Table'[Date]))
RETURN
COALESCE( LYValue, 0 )
Full solution file attached.
- Brian
eDNA Forum - Using Coalesce example solution.pbix (689.4 KB)