Forum Discussion
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
- amitchandakSuper User
Anonymous
Please refer this file for this week vs last week's calculation
https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0
- v-diye-msftCommunity Support
Hi Anonymous
you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.