Forum Discussion
Solved
Inventory Management
Trying to manage inventory and monitor value of inventory. You build inventory by buying products. When you sell the inventory value drops. If you buy 100 units of a product at 200 dollars , ...
Hi RNair ,
Sorry for the late reply, yes you are correct recursive calculation cannot be done in DAX, you can simulate it but no exaclty a recursive.
You can do it in Query editor using a formula.
https://www.poweredsolutions.co/2019/07/01/recursive-functions-in-power-bi-power-query/
Miguel,
Thank you for these responses.
I am coming up with a mathematical model that will not require any recursive calculations, but will still get me to the column L.
Once I have this spreadsheeted, and if I need help with the DAX implementation, I will put this up as a separate topic.
Even though I did not fully achieve what I wanted, I learnt a lot through this process.
Regards and Thanks again,
Ramesan Nair