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 
I was able to get correct numbers ofr the added rows. However, I went further and added even more rows and realized that cycling between positive to negative to positive more than one time will make the DAX solution impossible to achieve. What can be achieved with a simple function in excel cannot be achieved with DAX. In general DAX does not support recursive calculations but in some cases there are workarounds apparently not in this case.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I see, thank you very much tamerj1 for your generous help... If there is a work around, creating new measures or other calculated columns to achieve the desired result, I'm all ears... 

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Anonymous 

    Isthere a maximum number of restart cycles?

    • 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..

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        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?