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.

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 

when I reached the part when you said "If the previous week's Opening Stock After is negative, 0 should be used in the calculation of the current week's " I was like 😅

I don't think it's going to be easy. However, I have something in mind, let me try apply it tomorrow morning. Anyway, this is not going to be efficient by any means so I hope your data is not that big. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    hi tamerj1 

    thank you for helping 🙏