Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculating net stock by week

Hi,

I have data for forecast demand, firm demand and supply for a period of weeks. Initially I calculate net stock by subtracting safety stock from stock on hand, after that I take the previous week's net stock value, add supply and subtract forecast demand and firm demand. How would I create a measure that would be able to display this value in a graph and have a week slicer be able to show each value?

 

2 Replies