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
6 months ago

Hi yz___ 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

 

Thank You.