Forum Discussion
Help calculating inventory coverage
Hello,
I work for a retailer and am building a dashboard to help model inventory coverage based on our inventory and sales. I am using power query/ power pivot but I'm not too familiar with DAX functions so I was hoping I could get some help here.
The basic calculation I would like to do is for inventory coverage that I can bring into a pivot table. We calculate inventory coverage as: inventory/(sales for last 4 weeks/4).
here is a link for a sample data set of what I am using showing the sales and inventory of the stores and warehouse:
Here is a basic picture of a pivot table I'm using:
Thanks for your help!
5 Replies
- CNENFRNLCommunity Champion
Hi, redalert787 , but your mockup dataset doesn't contain amount of sales?
- redalert787Helper II
I've updated the sample set worksheet here: https://amersportsonline-my.sharepoint.com/:x:/g/personal/ardi_sardashti_amersports_com/EeSjobC4xgZFhMiDfIdVbcsBnrYPiy9-luplbXH4apdfJg?e=6rSItS
Thanks,
- redalert787Helper II
Hi CNENFRNL , my apologies I should have changed the name. In the mock up "inv net units" in column Q is the net sales. where was "Total inv" is the inventory in the stores or warehouse.
- redalert787Helper II
Hi,
can anyone help on the above??? here is an updated link to the sample data set:
- Syndicate_AdminAdministrator
I have the same issue. Can someone help here?