Forum Discussion
Running Total Issue for blank values
Hello, I have a table with date, amount,code,location. It has missing months, I have created a table that has all month data. I have related this table to solve the issue of the missing date. My amo...
Hi Anonymous
Let me know if you'd like to get below desired running total:
RunningTotal = CALCULATE(SUM(Table1[Value]),FILTER(ALL(Table1),[Date]<=MAX(Table1[Date])))
Hi, Ashish_Mathur
For missing dates it is showing zero as the category/code column will be blank for the missing dates thus it is not calculating the running total according to the code.
I can't share the file. For example, I have created the date table to get all the month-end value. Showing the sample for 1 activity/code below.I have around 10 codes. Hope I am clear with my requirement.
| Code | Date | Value | Running total | Desired |
| A | 1/31/2015 | 10 | 10 | 10 |
| 2/28/2015 | 0 | 10 | ||
| A | 3/31/2015 | 40 | 50 | 50 |
| 4/30/2015 | 0 | 50 | ||
| 5/31/2015 | 0 | 50 | ||
| 6/30/2015 | 0 | 50 | ||
| A | 7/31/2015 | 80 | 130 | 130 |
| 8/31/2015 | 0 | 130 | ||
| A | 9/30/2015 | 990 | 1120 | 1120 |
| A | 10/31/2015 | -1000 | 120 | 120 |
| A | 11/30/2015 | -200 | -80 | -80 |
| A | 12/31/2015 | 2000 | 1920 | 1920 |
Hi Anonymous
Let me know if you'd like to get below desired running total:
RunningTotal = CALCULATE(SUM(Table1[Value]),FILTER(ALL(Table1),[Date]<=MAX(Table1[Date])))