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

 

Try this

 

First Create a CombinedTable. From the Modelling Tab>>NEW TABLE

 

CombinedTable =
UNION (
    SUMMARIZE (
        Inward,
        Inward[Date],
        Inward[Size],
        Inward[Type],
        "Quantity", SUM ( Inward[Quantity] )
    ),
    SUMMARIZE (
        Outward,
        Outward[Date],
        Outward[Size],
        OUTward[Type],
        "Quantity", - SUM ( oUTward[Quantity] )
    )
)