Forum Discussion
Create Historical Stock
Hi,
Share the download link of the PBI file. Ensure that in the Stock Table, there is a Date column.
Hi,
I have solved a similar problem in the attached files where closing stock has to be calculated from opening stock, purchases and sales. Yours is the reverse case. Please try to adapt the solution to your specific case.
Hope this helps.
Dear Ashish
Thank you for your suggestion.
I have reviewed both files and the example1 is close to the solution.
But... In you file, the initial backlog is starting from Dec. 1 2022. and all calculation is creating 2023 opening backlog, revenue, expenses and closing backlog.
I need to start from today and it is closing backlog.
One of my idea is that I can use the entire revenue and bill (in your file) with running until previous month.
This means the entire - running is accumulated value (dates backward).
I am trying but not easy.
If you can help, that would be better...
Anyways, your files helps a lot.
Hi,
Share the download link of the PBI file. Ensure that in the Stock Table, there is a Date column.
Dear Ashish
With your file, I added my idea that the Entire R - until R and the Entire E - until E.
I successfully made all stock information based on date!
Thank you for your great help!
You are welcome.