Forum Discussion
Creating a running total with values from a measure
I've created a measure to get to certain values, after that I want the outcome of this measure in a running total, can't get to a solution. Any suggestions?
This is what I'm working with:
4 Replies
- amitchandak
Super User
With a date calendar try
Cumm = CALCULATE(SUM([Weight (ad)]),filter(date,date[date] <=maxx(date,date[date])))To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/Thank you for the quick response but the suggested measure doesn't seem to work.
Most likely due to the fact that Weight (add) is aready a measure by itself. Any suggestions on how to resolve this?
Cumm = CALCULATE(SUM([Weight (ad)]),filter(date,date[date] <=maxx(date,date[date])))
- amitchandak
Can you share sample data and sample output.
