Forum Discussion
RNair
Helper I
Helper IInventory 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/
MFelix
Super User
Super UserHi 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/
Hi, i have same problem. But how can do from quary editor? Could you please help