Forum Discussion
Inventory Management
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/
Am I correct in saying that because this is a recursive calculation it cannot be done in DAX?.
Please advise.
Regards,
Ramesan
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
Hi, i have same problem. But how can do from quary editor? Could you please help
