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
ImkeF
Community Champion
Community ChampionHi tringuyenminh92,
yes, performance is an issue if you do it in M/the query-editor, therefore the suggestion for a measure.
But the Partition-step in my query helps if for whatever reason you want to do it in M ;-)
tringuyenminh92
Memorable Member
Memorable MemberHi ImkeF,
The measure approach is clear to me. Could i have your sample pbix file that you are doing the converting with above M script, so I could quickly observe step by step to understand the role of Partition step? :smileyvery-happy: