Forum Discussion

redalert787's avatar
redalert787
Helper II
5 years ago

Help needed DAX formula for calculating inventory coverage

Hello, 

 

I posted this earlier but I never got a response. I'm wondering if any DAX wizards can help with the below:

 

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

 

Ideally, the equation of inventory coverage just because a formula that I can look at in the pivot table across stores or across product category etc. I'm just having a hard time getting the calculation in DAX. It would be a pretty simple one in calculated formulas in a normal pivot table so if someone can guide me in the right direction, I would really appreciate it. 

 

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/EeSjobC4xgZFhMiDfIdVbcsBnrYPiy9-luplbXH4apdfJg?e=DcWaqP 

 

 

Here's an example of the pivot table currently: 

 

 
 
 

Need Help

1 Reply

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    5 years ago

    redalert787  Sorry, I'm not sure what you're trying to do? The pivot table you posted - that is just a simple matrix visual in Power BI, but I don't think that's the final result you're looking for?

     

    How do you know which Warehouse relates to which Sales/Stores? 

     

    Also, in your sample file the Total Inventory column is empty?

     

    Please provide desired output, and sample values for all columns of data and we can help better.