Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help please on DAX: Calculated Column

Hello all,   Posting here again as I'm still unable to get an answer, sincerely appreciate all insights.   I would like to have a formula that creates the column "Opening Stock After" for the cur...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

     Anonymous 
    Please find attached modified sample file. Note that performance would be most probably bad.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

tamerj1 
Or 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).