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
Hello Zubair_Muhammad
Again thank you for your prompt replies and sorry for all the trouble.
I tried your file and it seems to be working to a certain extent.
I tried to put some more data into it after having skipped a day or 2 and when I use the skipped date on the slicer it does not show me the data for that day.
For Eg:
| Date | Size | Type | Quantity | Price | |
| 03-01-18 | 10x10 | A | 40 | 20 | Closing Stock |
| 05-01-18 | 10x10 | A | 10 | (-) Sale |
So if I select 4th Jan on the slicer, everything goes blank and there is no closing stock for it.
I am trying to generate a real world scenario, where there will be holidays, so there will be no outward or inward on some dates.
I have created a Calendar table, as you must have seen in the file I sent.
Also is there some way that I can get the closing stock for the last date of that month, if I put the month-Year on the slicer.
If you could please find a solution to these.
I am also updating the PBI and excel files on my OneDrive, if you it reduces your work and so that you know what I am doing wrong.
https://1drv.ms/f/s!Ap0qSKP-4qpThCGX0VuaSk-I9cxx
Again sorry for all the trouble and thank you for being so helpful.
Vishesh Jain
Thank you for your help.
As you might have figured out by now, I am quite new to Power BI and the coding behind it.
I am trying to implement BI in my organization and not many people here are familiar with it, that is why I have multiple threads running at the same time.
Again, sorry for all the hassle.
Thank you,
Vishesh Jain
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
You are welcome.
Following post mentions some good sources for learning
http://community.powerbi.com/t5/Desktop/Power-BI-Learning/m-p/336089#M150393
I already have the Definitive Guide to DAX by Ferarri,Rossi.
It is quite good but it is turning out to be a little too technical for me, when it comes to complex formulas.
I do have the basic understanding of the formulas but I fail miserably when it comes to complex ones.
Off the list that you have mentioned in the link, which book would you recommed, I get first, cause I don't know how technical each one is and you seem to have read them all.
Thank you,
Vishesh Jain