Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Inventory Forecast Recursive Calculation

Hi all, I'm trying to create a DAX measure that populates "forecasted remanining inventory".   I have gone through Gerhard's blog on recursive calculation, but it talks about compound interest and ...
Need Help
Interkoubess's avatar
Interkoubess
Solution Sage
8 years ago

Hi Anonymous,

 

With the printscreen what are your expected outcomes?

 

Please give the dummy data( easy to manipulate, not a printscreen) as well as your expected results and then i can m ake a try...

 

Ninter

  • janesmith's avatar
    janesmith
    New Member
    8 years ago

    Hi, I have the same problem too. Can someone please help?

     

    Thank you very much!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi Anonymous,

     

    Is this your expected result?  You may download the file from here.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Ashish, thank you so much. 


      What if I have a new inventory value in February, and I'm supposed to take that value for the DATESYTD calculation? Do I use the LASTNONBLANK function?

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        I think my solution should still work.  Please try it.