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
Thak you!
it was exacly my mistake!
Tell me please, how did you include the data in .pbix file?
Hi Tiolan,
this is a very common error. One should always hide the fact-table's date columns from view. Or better: Hide the fact-tables completely. (And put your measures into "blank-measure-only"-tables).
You can use the Enter-data-feature to copy-paste tables from Excel or wherever: http://powerbi.tips/2016/04/manually-enter-data/