Forum Discussion
How to Calculate Inventory Days Using DAX
Hi, I am new to using Power BI and DAX functions. Appreciate if anyone could help me with this. I want to calculate the Inventory Day of a list of materials (also categorise by MRP) based on ...
Hi amitchandak , first of all thanks for the help, much appreciated !
The purpose of calculating the Inventory Days is to understand how many days of stocks we are holding versus the previous months COGS. As you can see below, the coverage of the Inventory could varies instead of a fix 3 months. Example, for 1RL inventory it covers about 2 months+ (65 Days), for 4RL inventory it covers about 5 months (150 Days).
I have added a Date table in my power BI and an example file link attached. I would love for your help here with the formula. Thanks once again.
PBIX file: https://drive.google.com/file/d/1doO1tsVJas4WinqOevgF80dOxQkMxNUt/view?usp=sharing