Forum Discussion
Need help please on DAX: Calculated Column
Anonymous
Please find attached modified sample file. Note that performance would be most probably bad.
tamerj1
No, it is random depending on the Demand/Proposed Shipment for the current week as well as the previous week's Opening Stock After..
Anonymous
I know its random but in general can we say this cannot happen for example more than 5 times or it can be much more?
Good morning tamerj1
I've tried the code above and adjusted it accordingly to the maximum number of weeks that my dataset could span over and so far it works! I can't thank you enough for your big hearted help over the past few days... you made my week and I hope you have a great weekend ahead, thank you 😃Anonymous
Please find attached modified sample file. Note that performance would be most probably bad.tamerj1
Actually yes, you could say the maximum restart cycles is the number of weeks that the current dataset spans over (e.g. Week 31-37, maximum restart cycles = 6).