Forum Discussion

yz___'s avatar
yz___
New Member
7 months ago
Solved

Stock Tracking Resetting

Hi All,   I am trying to currently create a stock depletion forecast, with two different excel files, both have been imported and the way it works is that one has the stock with part number, and th...
Need Help
  • v-karpurapud's avatar
    v-karpurapud
    7 months ago

    Hi yz___ 

    Thank you for your question on the Microsoft Fabric Community Forum.


    While I’m not fully aware of the exact structure of your dataset, I’ve created a sample .pbix file to demonstrate one possible approach for modeling stock depletion over time by part, ensuring the rolling balance depletes correctly without resetting due to date hierarchies or aggregation issues.

    I’ve attached a screenshot and the .pbix file illustrating this logic. Please review them to confirm whether this approach aligns with your requirements.

     

    I hope this information is helpful. . If you have any further questions, please let us know. we can assist you further.

     

    Regards,

    Microsoft Fabric Community Support Team.
     

     

v-karpurapud's avatar
v-karpurapud
Community Support
7 months ago

Hi yz___ 

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.