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
Thanks!
But i need to use the numbers in the formulas...
But i need to use the numbers in the formulas...
- tringuyenminh92
Memorable Member
Hi 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.- dkay84_PowerBI
Microsoft Employee
Have you considered using "group by" in the query editor? After grouping appropriately you can apply the common cumulative total DAX pattern to get the result
