Looking to create weekly OH for 52 weeks. How do i calculate the dates

[shophoney]

Hi I have an OH report that calculates the current OH. I would like to figure out what the OH was each of the last 52 weeks.

I need to take OH + SALES + UNITS SENT - UNITS RECEIVED
to figure out the balances of each of the prior 52 weeks.

Do I have to create 52 measures? Is there a better way?
1YR AGO ON HAND TOTAL:=CALCULATE(tblInvSkuMaster[ON HAND + IN TRAN TOTAL]-'tblInvSkuMaster'[UNITS RECEIVED LAST YEAR]+tblInvSkuMaster[UNITS SOLD LAST YEAR])

UNITS SOLD LAST YEAR:=CALCULATE('tblInvSkuMaster'[SALES TOTAL UNITS SOLD],DATESBETWEEN(dCalendar[DATES],TODAY()-366,TODAY()))

Thanks

 

[bkjohn2016]

Can't you just add a week count to your calendar table?