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
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