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/
I see what you mean. That's going to be quite tough. There's recursion there and DAX doesn't lend itself well to that. I'll have a closer look later but I doubt it can be done in the way you propose.
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
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