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.
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.