Forum Discussion
vijaykumarj19
Microsoft Employee
Microsoft EmployeeCumulative sum zero values should display previous values till end values
| c1 | c2 | c3 |
| may 2020 | 32 | 32 |
| jun 2020 | 22 | 54 |
| jul 2020 | 54 | |
| aug 2020 | 54 | |
| sept 2020 | 34 | 88 |
| oct 2020 | 2 | 90 |
| nov 2020 | ||
| dec 2020 |
I have c2 column and need to display c3 running total but blank values before last value should display previous values
my table is connected to date table
my measure:
CALCULATE(
sum(c2),
FILTER(
CALCULATETABLE(
SUMMARIZE(
'Date Table',
'Date Table'[cc_year-Month Sort],
'Date Table'[Year Month]
),
ALLSELECTED('Date Table')
),
ISONORAFTER(
'Date Table'[cc_year-Month Sort], MAX('Date Table'[cc_year-Month Sort]), DESC,
'Date Table'[Year Month], MAX('Date Table'[Year Month]), DESC
)
)
)
but displaying cumulative till last
12 Replies
- wdx223_Daniel
Community Champion
vijaykumarj19 assume c1 from date table then try this code
=var _currentYM=max(datetable[year month]) return calculate(sum(c2),datetable[year month]<=_currentYM)
vijaykumarj19Its not showing cumulative count
- vijaykumarj19
My table
calculating cumulative and ploted in line graph
Below line should stop at a6
Dax :
c2 running total in c1 =CALCULATE(SUM('Table'[c2]),FILTER(ALLSELECTED('Table'[c1]),ISONORAFTER('Table'[c1], MAX('Table'[c1]), DESC)))
If tried same scenario and try to filter the data by using slicer which I created from date field it is not giving correct count.
