Help calculating inventory coverage

[redalert787]

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: 

https://amersportsonline-my.sharepoint.com/:x:/g/personal/ardi_sardashti_amersports_com/EeSjobC4xgZF... 

Here is a basic picture of a pivot table I'm using: 

Thanks for your help! 

[Syndicate_Admin]

I have the same issue. Can someone help here?

[redalert787]

Hi, 

can anyone help on the above??? here is an updated link to the sample data set:

https://amersportsonline-my.sharepoint.com/:x:/g/personal/ardi_sardashti_amersports_com/EeSjobC4xgZF... 

[redalert787]

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. 

[CNENFRNL]

Hi, @redalert787 , but your mockup dataset doesn't contain amount of sales?

[redalert787]

I've updated the sample set worksheet here: https://amersportsonline-my.sharepoint.com/:x:/g/personal/ardi_sardashti_amersports_com/EeSjobC4xgZF... 

Thanks,