Forum Discussion
Closing Stock Calculation
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
To get the Missing Dates, we can create another Table
Final Table = CROSSJOIN ( ALL ( CombinedTable[Date] ), ALL ( Inward[Size], Inward[Type] ) )
Then Add a calculated Column to it as follows
Closing_Stock =
VAR maxdate =
CALCULATE (
MAX ( CombinedTable[Date] ),
FILTER (
CombinedTable,
CombinedTable[Date] <= 'Final Table'[Date]
&& CombinedTable[Size] = 'Final Table'[Size]
&& CombinedTable[Type] = 'Final Table'[Type]
)
)
RETURN
CALCULATE (
VALUES ( CombinedTable[Closing Stock] ),
FILTER (
CombinedTable,
CombinedTable[Size] = 'Final Table'[Size]
&& CombinedTable[Type] = 'Final Table'[Type]
&& CombinedTable[Date] = maxdate
)
)