Forum Discussion
Helper IVRUNNING SUM OF A MEASURE
Hi All,
I have a requirement to blindly calculate the running sum of a measure. Given below is my sample data.
Column 1,2,3 is my source data.
Colum 4 = Calculated measure
Column 5 = running total
Column 6 = expected running total (how to achive this)
PLease help. thanks
| Date | A Value | B Value | MEASURE = IF SUM(B)=0 THEN 0 ELSE SUM(A)/SUM(B) | ACTUAL RUNNING SUM OF COLUMN D | REQ RUNNING SUM OF D |
| 1-Feb | 10 | 5 | 2 | 2 | 2 |
| 2-Feb | 20 | 10 | 2 | 2 | 4 |
| 3-Feb | 15 | 0 | 0 | 3 | 4 |
| 4-Feb | 40 | 10 | 4 | 8.5 | 8 |
4 Replies
- amitchandak
Super User
Running total will need some incremental context. Like a date , id, etc. to use <=. What we can have here.
revansh- amitchandak
Have a date table and try like
Cumm Sum = CALCULATE(SUM(Table[B]),filter(date,date[date] <=max(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/Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin
v-lionel-msftCommunity Support
Hi revansh ,
Could you give me the mathematical formula for these two columns? I do n’t know how they are calculated, I can help you convert to DAX formula.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
