Forum Discussion

V1's avatar
V1
New Member
4 years ago
Solved

Closing and opening inventory calculation

Hi All,  I have been strugling with an issue and hope someone can help me with a suggestion. Problem: I would like to calcuate the future closing/opening inventory based on production and sales fo...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    4 years ago

    If you keep the Opening Inventory white cells in a separate column, this should be a simple task of running totals where you calculate:

     

    [Open Green Column Value] + [Production FC] - [Sales FC]

     

    and use variables or time intelligence to calculate the running total of that expression. 

     

    Do similar with the closing balance, just adjust the filters slightly.

     

    Do you have a DimDate table?

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
4 years ago

V1 Just if you need help writing the running total measure it's necessary to know what the data model looks like. Are you comfortable writing running totals, or do you want more guidance on that?

V1's avatar
V1
New Member
4 years ago

AllisonKennedy I have not done it before but I understand the dax behind it. Let me try to solve this by using your feedback and I will come back once I solved or need further help. Many thanks for the quick resposes!!!!