Forum Discussion
Anonymous
4 years agoNot applicable
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...
- 4 years ago
Anonymous
Please find attached modified sample file. Note that performance would be most probably bad.
Anonymous
4 years agoNot applicable
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).
tamerj1
4 years agoCommunity Champion
Anonymous
Please find attached modified sample file. Note that performance would be most probably bad.
- Anonymous4 years agoNot applicable
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 😃