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 qua...
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
tringuyenminh92
Memorable Member
Memorable MemberHi Tiolan,
You could use Matrix control (but remember to fill in the transaction that has 0 quantity)