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/
AIB,
Thank you the response and the advice.
I am a little bit disappointed such an incredible software has got an inherent weakness like this.
Have spent almost a couple of months studying DAX now, and am really impressed with its abilities but this has rocked my faith a bit.
Please spend a little time when able to look at this and advise if any ideas possible.
Thank you again and good night.
Regards,
RNair
Let's see if any of these knowledgeable people have ideas:
Zubair_Muhammad , mahoneypat , MFelix , MattAllington , Greg_Deckler GilbertQ