Forum Discussion
Solved
Convert transactions to balance
Hello, Comunity.
Help me please :)
I have a transaction table and I can't find the way to calculate stock for certain date.
Example data:
In result, it should be certain quantity for each wharehouse for each SKU for each date.
I would appreciate any help with Idea and suggestions.
Yes, I'd say the measure is the way to go here. It should work as desired in the chart if you take the date-field from your date-table and not from the transactions-table.
Link to file: https://www.dropbox.com/s/dc8budcqd68ogz4/PBI_CumTotalAllDates.pbix?dl=0
20 Replies
- tringuyenminh92
Memorable Member
Hi Tiolan,
You could use Matrix control (but remember to fill in the transaction that has 0 quantity)
- Thanks!
But i need to use the numbers in the formulas...- tringuyenminh92Hi Tiolan,
What formula? Could you please describe your expectation? So I could figure out possible approach.- Thanks for helping!
For example, build a diagram, that describes the dynamic of stock of certain sku in certain warehouse. I need to have all this data in a table, not only on visualization.
