Forum Discussion

mail2vjj's avatar
mail2vjj
Helper III
8 years ago
Solved

Closing Stock Calculation

Hello, I have the following 2 tables. First one is Inward and second one is Outward.   Inward       Date Size Type Quantity 01-01-18 10x10 A 100 01-01-18 20x20 B 100 01-...
Need Help
Show and Tell
Tips and Tricks
  • mail2vjj's avatar
    mail2vjj
    8 years ago

    Zubair_Muhammad

     

    Thanks again for taking the time to help me out.

     

    I have updated my file to get the closing stock after taking into consideration the last date for every month, all thanks to your help. I have created a new measure 'On Hand Quantity' in the 'Final Table'.

    Here is the link:

    https://1drv.ms/f/s!Ap0qSKP-4qpThCGX0VuaSk-I9cxx

     

    Now I am trying to get the prices in my closing stock table, so that all my closing stock can be bifurcated.

     

    I would really like to know from where have you learned how to code DAX cause you are so quick with your solutions and they work!

     

    I have been spending hours an hours and not getting any results. If you could please tell me if there is any book that I can use to learn how to code in DAX.

     

    Again a huge thanks for all your help.

     

    Vishesh Jain

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

mail2vjj

 

Then add this MEASURE in this new Table

 

Closing_Stock =
CALCULATE (
    SUM ( CombinedTable[Quantity] ),
    FILTER (
        ALLEXCEPT ( CombinedTable, CombinedTable[Size], CombinedTable[Type] ),
        CombinedTable[Date] <= SELECTEDVALUE ( CombinedTable[Date] )
    )
)