Forum Discussion

redalert787's avatar
redalert787
Icon for Helper II rankHelper II
5 years ago

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 ...
Need Help
redalert787's avatar
redalert787
Icon for Helper II rankHelper II
5 years ago

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.